Recently, I had the pleasure of writing another article that was included the Notes From the Field series that is hosted out on SQLAuthority.com. This tip was my first one working with Azure. To me its remarkable how quickly you can spin up an instance to help you build…
Latest Blog Posts
By Steve Bolton
…………In the last edition of this amateur series of self-tutorials on finding outlying values in SQL Server columns, I mentioned that Grubbs’ Test has a number of limitations that sharply constrain its usefulness to DBAs. The Generalized Extreme Studentized Deviate Test (GESD) suffers from some of… Read more
The log file is one of those parts of SQL Server I find fascinating. For instance it is composed of VLFs (virtual log files). These VLFs are a logical way for SQL to break the physical file down into smaller pieces. These pieces are then marked as “in use” or… Read more
‘Twas 4:45 Friday, and all through the office
not a creature was stirring, not even the bosses.
The code was checked in, into Tortoise with care,
in hopes a release date – soon would be there.
The devs were all slumped – in front of computers,
while prospects of bonuses… Read more
I noticed a contest this week while working on the Database Weekly newsletter. It’s the Cloud Hero contest, with the chance to win a Surface Pro 3. I could always use another device, or at least a device I could give away, so I decided to enter.
There are… Read more
I’ve been running WordPress for years now and find it to be a solid solution for what I want to do. The only negative in my view is the requirement to use mySQL. There’s nothing wrong with mySQL itself, it more than does the job. I can quibble that it… Read more
Row_Number SQL Server
SQL Server includes several Ranking Functions that can be called in T-SQL. One of these is the Row_Number() function. You can use this function to return a sequential number in your result set that begins at 1.
There are 2 arguments that can be passed into the… Read more
Last week I had the honor to present a seminar at Expert Days 2014, which is an annual conference for developers organized by E4D Solutions. I suggested the title “SQL Server Developer Tips that Can Save Your Ass”, but the organizers didn’t like it, so they changed it… Read more
Recently I was working on transforming some dates, and wanted to generate a large n number of dates for testing. I decided to use SQL Data Generator, and a little RegEx to meet my needs.
The format I needed was CYYMMDD, which is the century as a 0 or 1… Read more
Have you ever had a mental block in one particular area when learning something? It might be the simplest thing, but for some reason your brain turns to Teflon when you try to store the information. For example, I have a degree in Math, so I am pretty good at… Read more
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
You should benchmark your storage immediately. If you are a database administrator, you should benchmark it yesterday. And today. And next week.
Well, that’s exaggerating things a bit… but storage performance should be at the core of your ongoing performance metric collection and test process. Storage performance matters that much… Read more
Most of my peers, and likely yours as well, work in some sort of technical field. Odds are that they’re proficient readers who can digest the driest of technical material. They’re probably good with math, and a large portion of them are likely science geeks. How many of them can… Read more
When it comes to implementing a big data strategy in a Microsoft SQL Server shop, you’re generally going to consider one of three strategies. In the first strategy, which I won’t be addressing today, you might choose to tackle your big data architecture by pushing your relational database to… Read more
This is just something I was curious about. I ran my tests and got an answer and now I thought I would share.
The Analysis Services Performance Guide from bunch of Microsoft Analysis Services experts have been updated since 2005 edition for 2008 R2 and for 2012.
- Microsoft SQL Server 2005 Analysis Services Performance Guide
- Microsoft SQL Server 2008 R2 Analysis Services Performance Guide
- Microsoft SQL Server Analysis Services Multidimensional Performance and Operations…
I didn’t want to repeat the Night Before Upgrade again this year, so I wrote something new. Go ahead, sing along, you know the tune!
Go, they told me, pa rum pum pum pum
The D-B-A to see, pa rum pum pum pum
Your query runs too slow, pa rum… Read more