Ever jump on a machine to connect to a SQL Server and find out… whoops! No tools. For some reason, the client machine doesn’t have SQL Server Management Studio (SSMS) installed. Now I’m not talking about not having the SSMS installed on the server, but on the local workstation that you need to connect to [...]
Ever need to group dates and round them to intervals? I had this exact need for a report on wait stats I was working on for an upcoming post. I wanted the flexibility to be able to group a list of dates by either minute, hour, date, etc. And then also round those dates within [...]
Michael Swart (Database Whisperer) posted a great write up and interview with Brad Schulz that is worth checking out. Michael’s post links to a post from Brad on the use of EXIST and what is required for the SELECT portion of the statement. Hope you are still with me. Definitely worth the read and +1 [...]
Coming up this month is a free event to discover more ways to write T-SQL here is an event for you. The session will be hosted by yours truly and features T-SQL tricks and tips that I’ve picked up and want to spread the word on. Here is the registration link. And the details: Course [...]
In less than a month SSWUG will be hosting the Ultimate Virtual Conference on October 21-24. This is an excellent opportunity to get the benefits of heading to a conference full of Rock Star speakers while be able to view the content from the comforts of home or your desk. Reasons to Attend Some of [...]
The Minnesota SQL Server user group (PASSMN) meeting is tonight at the Microsoft offices. Come check us out to network and mingle with your peers and also for the opportunity to learn some new things. Tonight’s topics are: Syntactic Sugar Sweetens the SQL Server Pot Discover and Manage SQL Server in the Enterprise If you [...]
Well… until next month of course. If you’re in Minnesota and reading this… and don’t mind sharing some snacks with other like minded SQL professional… then come down and join us for this month’s SQL Server user group meeting. We’ll be in a different location for this month – across the skyway from the normal [...]
Coming up in a couple weeks is the next PASSMN meeting. We’ll be in a different location for this month – across the skyway from the normal meeting spot. But that puts us right over a coffee shop… not a bad tradeoff for the coffee drinkers in the the group. Without ado here are this [...]
About a year ago I was working on a project that required that data be extracted from one database and inserted into an database. Not the most earth shattering concept. This is done quite often and doesn’t necessarily require a discussion of foreign keys. So why talk about them… well… in this case the source [...]
I really like a great idea. They have this way of going from a great idea to success. When you hear a great idea it is always a good idea to share the idea – and let it spread like a virus. Today, while I was going through and reading posts from Microsoft’s SQL Server [...]
_1262.png)
