If you can establish a connection to a SQL Server, but are having problems logging in to it, you will get an 18456 error. This error is deliberately obfuscated in SQL Server so that the user can’t tell why the error failed (and thus try to crack into the server). All the user will get [...]
Book List
Planned books:
- SQL Server 2008 Query Performance Tuning Distilled (Expert’s Voice in SQL Server) by Grant Fritchey, Sajal Dam
- The Red Gate Guide to SQL Server Team-based Development by Mladen Prajdic, Grant Fritchey, Alex Kuznetsov
- Troubleshooting SQL Server – A Guide for the Accidental DBA by Jonathan Kehayias, Ted Krueger
Current books:
-
Microsoft® SQL Server® 2008 Internals (Pro – Developer) by Kalen Delaney, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Adam Machanic
Recent books:
- Threat Vector by Tom Clancy, Mark Greaney
- Poseidon’s Arrow (Dirk Pitt Adventure) by Clive Cussler, Dirk Cussler
- The Tristan Betrayal by Robert Ludlum
- The Race (An Isaac Bell Adventure) by Clive Cussler
- SQL Server MVP Deep Dives Vol. 2 by Unknown
We all have a bucket list – that list of things that we want to accomplish before one, well, kicks the bucket. Perhaps you want to ski the Swiss Alps. Learn a foreign language. Learn to play a musical instrument. Surf the Hawaiian swells. Visit far-away places. Get romanced by a Frenchman in Paris (which [...]
It’s time for our monthly blogging party, commonly known as T-SQL Tuesday. This month, Bob Pusateri is providing the motivation by selecting the topic, and he would like to know how we came to love presenting. Being the inquisitive type, Bob would like to know things like what was the first time you gave a [...]
Welcome to Day 28 of my “A Month of PowerShell” series – the last day. This series will use the series landing page on this blog at http://blog.waynesheffield.com/wayne/a-month-of-powershell/. Please refer to this page to see all of the posts in this series, and to quickly go to them. During this series, we’ve learned how to [...]
Welcome to Day 27 of my “A Month of PowerShell” series. This series will use the series landing page on this blog at http://blog.waynesheffield.com/wayne/a-month-of-powershell/. Please refer to this page to see all of the posts in this series, and to quickly go to them. One of the tasks that we are frequently called upon to [...]
Welcome to Day 26 of my “A Month of PowerShell” series. This series will use the series landing page on this blog at http://blog.waynesheffield.com/wayne/a-month-of-powershell/. Please refer to this page to see all of the posts in this series, and to quickly go to them. If you utilize the sa login to perform admin chores (instead [...]
Welcome to Day 25 of my “A Month of PowerShell” series. This series will use the series landing page on this blog at http://blog.waynesheffield.com/wayne/a-month-of-powershell/. Please refer to this page to see all of the posts in this series, and to quickly go to them. We all know that we need to run integrity checks on [...]
Welcome to Day 24 of my “A Month of PowerShell” series. This series will use the series landing page on this blog at http://blog.waynesheffield.com/wayne/a-month-of-powershell/. Please refer to this page to see all of the posts in this series, and to quickly go to them. One of the best practices that you should observe is to [...]
Welcome to Day 23 of my “A Month of PowerShell” series. This series will use the series landing page on this blog at http://blog.waynesheffield.com/wayne/a-month-of-powershell/. Please refer to this page to see all of the posts in this series, and to quickly go to them. Today, we’re going to look into the JobServer collections. The JobServer [...]
Welcome to Day 22 of my “A Month of PowerShell” series. This series will use the series landing page on this blog at http://blog.waynesheffield.com/wayne/a-month-of-powershell/. Please refer to this page to see all of the posts in this series, and to quickly go to them. Yesterday we backed up all of our databases. However, what good [...]
