the-sql-server-man.blogspot.com
The SQL Server Man: CPD
http://the-sql-server-man.blogspot.com/p/cpd.html
The SQL Server Man. Microsoft sql server musings. SQL Server To Do List. I really need to log CPD (Continuous Professional Development for those wondering) somewhere so I thought I would log online, it gives me somewhere I can easily find and might give other people some ideas. 07 Apr 2013 : Bad SQL Server Advice, Brent Ozar, .5 hours. 6 Apr 2013 : DBA Diary, Chris Page, 10 hours. 12 Mar 2013 : Logshipping Part 2 When Disaster Strikes, Brent Ozar, .5 hours. Subscribe to: Posts (Atom). The Page Family Blog.
the-sql-server-man.blogspot.com
The SQL Server Man: December 2013
http://the-sql-server-man.blogspot.com/2013_12_01_archive.html
The SQL Server Man. Microsoft sql server musings. SQL Server To Do List. Tuesday, 31 December 2013. I have been struggling with poor performance on my laptop for sometime, I had realised that the problem was a regular stoppage of everything but couldn't figure out what it was. Back to the topic, what I am missing is how to set the location of the auto-recovery files - I did search all the locations that are listed on line and my files were in none of them, I even manually created the folders in My Docume...
the-sql-server-man.blogspot.com
The SQL Server Man: May 2009
http://the-sql-server-man.blogspot.com/2009_05_01_archive.html
The SQL Server Man. Microsoft sql server musings. SQL Server To Do List. Friday, 1 May 2009. Using Sql Server Management Studio Offline. First post, a tip I desperately needed today. I have been using my laptop offline and occasionally find myself faced with a "cannot generate sspi context" error message. Now I can logon to the expected instance name and work with no problems. 5 minute fix. Click here for a discussion of the SSPI problem on SQL Server Central. Links to this post. I will credit the author...
the-sql-server-man.blogspot.com
The SQL Server Man: April 2013
http://the-sql-server-man.blogspot.com/2013_04_01_archive.html
The SQL Server Man. Microsoft sql server musings. SQL Server To Do List. Friday, 19 April 2013. I was trying to figure out how much space storage of nulls takes. There are any number of articles online (SQL Server 2012 and prior versions) saying that nulls take no space except for the 2 byte row overhead for having any number of nullable columns. However, I am convinced I read somewhere that null columns only take no space when they are not subsequently followed by non null data. I have a document called...
the-sql-server-man.blogspot.com
The SQL Server Man: SQL Server To Do List
http://the-sql-server-man.blogspot.com/p/sql-server-to-do-list.html
The SQL Server Man. Microsoft sql server musings. SQL Server To Do List. SQL Server To Do List. This is my SQL Server to do list, I suspect I'll never get to the end, in fact let's start with that thought in mind :. Tinker with the latest version. Read the blogs of the DBA greats, current favourites (alphabetical order, no favouritism) are Brent Ozar and associates. Feel free to suggest more! Read the enormous pile of manuals that is ever growing, remember to be thankful for PDFs. Modify the Check State ...
the-sql-server-man.blogspot.com
The SQL Server Man: January 2013
http://the-sql-server-man.blogspot.com/2013_01_01_archive.html
The SQL Server Man. Microsoft sql server musings. SQL Server To Do List. Wednesday, 30 January 2013. Adventures with Powershell, first steps. I keep hearing about this mysterious product that is now bundled with SQL Server in various guises called Powershell. Anyway, to date I found no practical purpose for me or the environment that I manage because everything it seems to offer I can do already via SQL Agent without having to learn arcane Powershell scripting and magic words. Enter the next service prov...
the-sql-server-man.blogspot.com
The SQL Server Man: Null storage
http://the-sql-server-man.blogspot.com/2013/04/null-storage.html
The SQL Server Man. Microsoft sql server musings. SQL Server To Do List. Friday, 19 April 2013. I was trying to figure out how much space storage of nulls takes. There are any number of articles online (SQL Server 2012 and prior versions) saying that nulls take no space except for the 2 byte row overhead for having any number of nullable columns. However, I am convinced I read somewhere that null columns only take no space when they are not subsequently followed by non null data. I have a document called...
the-sql-server-man.blogspot.com
The SQL Server Man: SSMS Auto Recovery
http://the-sql-server-man.blogspot.com/2013/12/ssms-auto-recovery.html
The SQL Server Man. Microsoft sql server musings. SQL Server To Do List. Tuesday, 31 December 2013. I have been struggling with poor performance on my laptop for sometime, I had realised that the problem was a regular stoppage of everything but couldn't figure out what it was. Back to the topic, what I am missing is how to set the location of the auto-recovery files - I did search all the locations that are listed on line and my files were in none of them, I even manually created the folders in My Docume...
the-sql-server-man.blogspot.com
The SQL Server Man: Tempdb
http://the-sql-server-man.blogspot.com/2013/02/tempdb.html
The SQL Server Man. Microsoft sql server musings. SQL Server To Do List. Tuesday, 19 February 2013. Useful article on tempdb and the numbers of files required : tempdb article. I tend to start with just two files and extend if experiencing performance problems simply because I've had a number of cases where tempdb activity is slower spread across lots of small files than running everything against fewer, large files. Subscribe to: Post Comments (Atom). Adventures with Powershell, finally some code.
