|
A SQL Server DBA attempts a personal IT project and documents the (mis)adventures.
Browse by TagsAll Tags » SQL Server (RSS)
-
|
In a previous blog post I talked about being puzzled as to why I wasn't able to get, in my mind, accurate table counts for a database in SQL Server 2005 that had over 50,000 tables. I kept getting only 1,000. With the help of Chad Miller , I've figured Read More...
|
-
|
Chad Miller , one of my favorite bloggers on SQL Server and PowerShell, has just announced the release of version 1.5 of SQLPSX . SQLPSX is a collection of functions, cmdlets, and scripts that make accessing SQL Server via PowerShell extremely easy. For Read More...
|
-
|
When I start to learn a new technology, I find I learn best if I jump right in, get my hands dirty, and play around with it for a while. After a couple initial ah-HA moments and early successes, I inevitably hit a wall where I can't seem to solve a particular Read More...
|
-
|
A request came in from one of the developers asking if there was a way to script out all of the triggers for a list of tables in a database on SQL Server 2005. This database has around 60k tables, and navigating to each of the 40 some tables that the Read More...
|
-
|
If your company is like mine, you are largely at the mercy of your software vendors as to when you'll be upgrading to SQL Server 2008. But, if you're like me, you want to start taking advantage of the features of the SQLPS mini-shell in your regular PowerShell Read More...
|
|
|
|