Latest Blog Posts
My wife, Molly, is one of the smartest (non-technical) people I know. Although she has learned a lot about what I do through osmosis as well as from reading in her spare time, she’s talented in many other ways besides understanding what SQL Server actually is and the difference between… Read more
Not the I/O that we think of in T-SQL, but more the I/O that’s a part of many programming languages. This… Read more
Make sure you start the month right by taking the time to make certain your SQL Server environment is performing and being maintained up to where you need. To do that you need to check to be sure that you have the right the right resources in place… Read more
Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of the servers you manage.This inventory can take any number of forms but, ideally, will allow some aggregation of information. When server hardware or software changes are taking place, it’s…
Me and Aaron Bertrand, SQL Sentry flagbearers.
One of the things we’ve been working on at SQL Sentry is building up institutional knowledge for the SQL Server community. There are three main ways that we’re doing that on-line:
- Hard-core tech articles on SQLPerformance.com, edited by long-time SQL Server MVP…
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (
so exciting), follow me on twitter (@StrateSQL). And see these throughout the day as I tweet out links of things I find interesting. While these links aren’t the answer… Read more
I ran across an issue that I haven’t seen since SQL 2000 and had almost forgotten about. Let’s do a quick review of ports in SQL Server. A default instance of SQL Server uses port 1433. That’s just the default and you can change it to whatever you want. Bear… Read more
I use Pocket for saving some stuff. It works well from Feedly when I see something I know I’ll want to look at again (or just later). I’m sure I don’t use it as much as I should or could, but I’m strangely slow to adopt tools sometimes – it… Read more
Few blog posts ago, I decided to build a virtual environment for a personal SQL Server sandbox. So, the Virtual SQL Playground Adventure blog series came to life.
In the introduction I promised to document everything but did not do a follow up blog post after that. That doesn’t mean… Read more
SQL Fiddle is a free website that you can use to demonstrate and save a query example in any one of 13 different DMBSs (as of this posting) including two different versions of SQL Server (2008 & 2012).
First you set up your work environment and “Build Schema”.
Then… Read more
Previously I wrote a blog on Top N and Bottom N reporting. There were a couple of gotcha I did not cover in that blog so I thought I would cover those here to answer some of the questions I have received. The other blog can be found here.
Recently I was working on a task that needs to handle various datetime calculations, and it is really fun.
Usually there are two types of approaches, one is to convert datetime value to string value and then through string calculations like substring, concatenation and convertion to get the result,… Read more
I’m a bit late getting this posted, so to the two of you waiting to see it, I apologize. Back on February 6th, almost a month ago already, I presented my “10 Ways To Abuse T-SQL” session for Dell. Due to my inability to watch the clock, those 10 ways… Read more
The role of PASS in the community has evolved a lot over the past few years. Back in 2006/2007 PASS was mainly about the Summit and trying to grow new chapters, not a lot of emphasis on doing more for chapters and not much interest in a day based event… Read more
I’m slightly behind here after holidays and some travel. Apparently my pop-up reminder for my own studies bears about as much… Read more
Come join me for this webinar on 3/13/2014 at 11:00 AM EST
The future of Business Intelligence has many new and exciting features. This world that was once reserved for only experts in SQL Server technologies has expanded to serve the masses with more and… Read more
I recently presented a free webinar for Pragmatic Works Free Training on the T’s about new Business Intelligence features in SharePoint 2013. If you attended I want to say thank you. It’s always a fun time presenting and the audience is always a lot of fun to interact with before… Read more
A good cure to a creepy doll is a good old post that is still useful. In this post, I’m going back over some of the posts that came out in this week in previous years. Having looked over these from time to time, I’m… Read more