Latest Blog Posts
Those of you who use SQL Server Analysis Services (SSAS) are likely familiar with the “bible” for designing cubes: Expert Cube Development with Microsoft SQL Server 2008 Analysis Services by Marco Russo, Alberto Ferrari , and Chris Webb. Well, a new edition has just been published, with a changed name… Read more
I often do my SharePoint setups on virtual machines since I need to build them up and tear them down frequently. Hyper-V is a beauty when it comes to demo environments. A few weeks ago I was doing an install and got an error that was absolutely no help.
Let’s throw out all the reasons why you need to do the…
My company cut the training budget this year, and it’s not that uncommon for that to happen anymore. However, I’m still getting my week of training in, and more, without paying much.
Blogs of people who talk too much – FREE
There’s so much for free online, but you’re reading… Read more
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
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email all the essential knowledge you need to know about performance tuning on SQL Server.)
Today I have uploaded the 11th SQL Server Quickie to YouTube. This time I’m talking… 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