SQL Server DBA Blog, with straightforward advice, quality resources and musings about SQL Server
I hope you’ve had a great week.
Here’s this weeks roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!
SQL Server Links
XML Validation in SQL Server Intergration Services – A nice walkthrough here from Simon Sabin.
SQL Azure Frequently Asked Questions – So what’s this SQL Azure all about then? Brent Ozar answers the most frequently [...]
I hope you’ve had a great week.
Have you got what it takes to be a SQL Server DBA or are you looking for that new SQL Server role? Be sure not to miss my Top 10 Junior DBA Interview Tips.
Here’s this weeks roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!
SQL Server Links
IN [...]
Registration for arguably the UK’s largest SQL Server event is now open.
To guarantee you do not miss out be sure to reserve your interest by registering here.
That’s right, the Microsoft SQL Server 2008 R2 Community Technology Preview (CTP) is now available for download.
SQL Server 2008 R2 CTP
Go ahead and take a look at the preview. It’s a great chance to get a first look and experiment with some of the new features. Be sure to let me know how you get [...]
If you are like me and absolutely gutted that you cannot attend the PASS 2009 summit, then this could be just the ticket that you have been waiting for.
Understandably if you live/work on the other side of the globe it is not exactly the most practical of away fixtures to attend and getting sign off [...]
What with so much awesome SQL Server and technology content being published each week, you can have a real tough time keeping up with it all. So if you’re like me and you have a bit of extra surfing time at the weekend, then you might like to use that time to catch up on [...]
This is just a quick update to let you all know that I have released confirmation of the successful entrants to the SQL Server Guru Challenge, so far. The league table can be found here however, everyone who has qualified so far has answered all questions correctly which means there is nothing to separate all [...]
I have received feedback from a few of you regarding the SQL Server Challenge qualification process as being perhaps a little too tricky.
So in order to get you all started I have added clues alongside each anagram.
Cavaliers Intentional Tools – (concurrency control)
Adapt Scuba Bake – (essential disaster recovery practice)
Even Jest So – (The big man [...]
Here’s a solution to an issue that you may have come up against when designing a SQL Server Reporting Services (SSRS) report requiring Datetime parameters, that uses a SQL Server Analysis Services (SSAS) data source.
What’s the problem?
When you create a dataset from a SSAS data source, by default the date values returned from a given [...]