Archives: July 2013
I will be presenting the session “Building an Effective Data Warehouse Architecture” this Wednesday, July 31st, at 10pm EST for the 24 hours of PASS, PASS Summit Preview. Info about the event, and the abstract for my session, is below. I hope you can make it!
Mark your calendars… Read more
Weekly round-up of the links that I tweet out number 43. As an introduction, if you follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of things I find interesting. While these links aren’t the answer to life, the universe, and… Read more
First time event in Cocoa Beach went really well!
- Speaker dinner well attended Friday night at Florida’s Seafood
- Quite a few out of town speakers, and it seemed like more speakers brought their families. Having the event at a hotel on the beach certainly made it
- What are the odds…
The site connect.microsoft.com is a wonderful concept: you can provide feedback about the Microsoft products, report bugs and give suggestions directly to the teams responsible for those products. People can vote on items to indicate them as more important.
At least, that’s the theory. It’s been known that the communication… Read more
Have you ever wanted to know how fast one of your core SQL Servers are running, or ever wanted to compare the raw performance of one server to another? Now you can – and for free!
Some folks at Dell developed a synthetic benchmark tool a while back that can… Read more
Reporting Services 2008 is a very powerful tool for creating reports. It contains many different tools and even allows you to place complex expressions on reports in every field. Even with all of these tools there are some instances where you need more functionality. This is where custom coding comes…
I’ve had to debug database mail problems several times over the last year or so. Below is a collection of the stored procedures and queries that I’ve ended up using. I’ve added notes to most of them to help explain and work with them.
USE msdb GO -- Check that…
There are several options available to import data from external sources to SQL Server. Such as Import & Export Wizard, BULK INSERT command, SSIS and OPENROWSET.
Apart from this options you can also use xp_cmdshell to import text file to SQL Server. We need to utilize dos command TYPE for… Read more
PASS is accepting candidate applications for the 2013 election through August 7th, 2013. Later this year we – the PASS membership – will be voting to fill three seats on the Board. To have a good election we need a great selection of candidates. I hope for a slate of… Read more
Well, these are exciting times for the Christchurch SQL SERVER User Group.
After a period of fragmentation where our meetings seemed to be at random intervals – mainly due to certain major events outside our control – such as earthquakes, the city… Read more
This year’s SQL Saturday #222 in Sacramento was a blast. This event was certainly the high point of my summer, and am very thankful to have been selected to speak here.
As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’s Training on the T’s, I received a large number of questions that there wasn’t time to answer. Instead of just a re-cap of all of the questions, instead I’ve opted… Read more
Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance
The foundation of database performance is the underlying server hardware and storage subsystem. Even the…
If you are looking for a presentation that brings together bacon, unicorns, and lightsabers, then you should have seen my presentation this past Thursday for Pragmatic Works Training on the T’s. The session was 5 Amazing Reasons DBAs Need to Love Extended Events. In it, I ran through… Read more