Kyle Neier
SQL Express and the Curse of the Perfmon Counters
While this warrior was only vaguely familiar with SQL…
0 comments, 1,116 reads
Posted in Kyle Neier on 5 February 2012
Delivering Three PTI SQL 2012 Firestarter Webcasts
You'll get to hear me share the greatness that is SQL Server during the following sessions:
2/16/2012
Throwing T-SQL 2012…
0 comments, 1,332 reads
Posted in Kyle Neier on 3 February 2012
Verifying Last Successful CheckDB with Powershell and SMO - sorta
6 comments, 1,551 reads
Posted in Kyle Neier on 3 February 2012
Eliminating Successful Backup messages with Powershell and SMO
1 comments, 919 reads
Posted in Kyle Neier on 17 January 2012
Safely Restart SQL Agent with Powershell
After weighing the options – look at Job Activity monitor for each instance, verify no running jobs, then restart the SQL Agent service or write a cool new Powershell…
0 comments, 1,516 reads
Posted in Kyle Neier on 5 January 2012
Modifying SQL Server Synonyms – this time with Powershell
1 comments, 1,526 reads
Posted in Kyle Neier on 26 December 2011
Modifying SQL Server Synonyms
1 comments, 1,157 reads
Posted in Kyle Neier on 20 December 2011
Adding Servers to SQL CMS (Central Management Server) using Powershell
Enter Powershell and SMO.…
1 comments, 3,065 reads
Posted in Kyle Neier on 13 December 2011
Sp_altermessage “Classic”, much better than “New” sp_altermessage
I was reading through the SQL Server 2005 SP3 release notes yesterday (sadly, it was enjoyable) and clicked through to the Bugs Fixed link. After reading through the KB articles that I felt had direct implications to my current environment, I kept scrolling.
Third fix from the bottom is one… Read more
0 comments, 784 reads
Posted in Kyle Neier on 19 December 2008
OLEDB Wait Stats in SQL Server 2005
0 comments, 694 reads
Posted in Kyle Neier on 3 December 2008
Workaround Primary Key Violations in SSIS
However, if you've encountered issues like I just did, this lazy DBA's approach might prevent…
0 comments, 1,474 reads
Posted in Kyle Neier on 26 November 2008
My first blog post -- starting small
I don't know it all, but I don't know nothing, I'm definitely somewhere in between. So, I hope to share these thoughts and hopefully help out people in similar ways as…
0 comments, 431 reads
Posted in Kyle Neier on 20 November 2008