-
NTFS fragmentation degrades SAN performance? Well it does for insane fragmentation....
-
Upgrading to SQL Server 2008 - Rob Carrol PFE; Resource Governor demo; SQL Nuggets and networking. Cost Free Register Via UK SQL Server User Group Address Microsoft Office at Waverley Gate, Edinburgh Directions to Event Scottish Area SQL Server User Group...
-
What’s new for a DBA in SQL Server 2008; Nuggets and networking Cost Free Register Via UK SQL Server User Group Address Leeds Metropolitan University Directions to Event What’s new for a DBA in SQL Server 2008? There are many great new features in SQL...
-
Business Intelligence - Creating an SSIS, SSAS & SSRS monitoring solution with SSIS, SSAS and SSRS; Data Mining - Marking Predictions over time Cost Free Registration Via UK SQL Server User Group Address Building 3, Microsoft Campus, Thames Valley...
-
When users migrate from SQL Server 2000 to SQL Server 2005, not all databases are set to Compatibility Level 90 which is required to make use of the newly available functions There are many methods to know the Compatibility Level of a database using queries...
-
The biggest feature of management studio that most people don't know about is the keyboard shortcuts for stored procedures. You can configure a shortcut i.e. CTRL+1 to execute a stored procedure. Whats more if you have some text highlighted it can...
-
Sean McCown has been given the MVP award in January this year. I did a google to find out somethings about him and came across a great article on SQL Server Central about great responses to interview questions from experienced DBAs it is so true though...
-
I was reminded this morning of how to rotate text in a report. I've also developed some code to do it by use of graphics if you prefer the text to go in different directions. More on that later - var height=90;var width=720;
-
This is a great list of demo tips from Buck . I would agree with Bill that you need to change the foreground hihghlighting to change I would also add that I find I often end up in Notepad and the command prompt so you need to set the font size in those...
-
If you want to follow you can hear http://twitter.com/simon_sabin - var height=90;var width=720;
-
Its shocking how many people don't even do the basics of ensuring your data is protected. I've just read this article http://itknowledgeexchange.techtarget.com/sql-server/mirroring-isnt-a-backup-solution/ about a company that ran JournalSpace...
-
So you've gone back to work and can't really get back into it after all that chocolate and booze. Here's a little challenge. Phil Brammer wondered what would happen to the usecounts column in the sys.dm_exec_cached_plans dmv when you hit the...
-
As a slightly seasonal touch of lightness I though I’d just do a comparison of DAS and SAN storage Item DAS SAN Basic Storage Cost Good Hideously expensive Ease of Use Simple How many storage engineers and system administrators does it take to change...
-
Yeah I know it's a silly title but I decided to up my testing by mirroring the database that I populate, that way I can create havoc on two servers at the same time and get a feel for how mirroring might be of use to me in the future, or not. One...
-
set nocount on select space ( 7 - len ( replicate ( char ( 42 ), no )))+ replicate ( char ( 42 ), no * 2 - 1 ) from ( select top 5 row_number () over ( order by name ) as no from sysobjects ) as t union all select space ( 5 )+ replicate ( char ( 124 ...