sequelqb.blogspot.com
SQL Server Question Bank: Error Handling in SQL Server 2005
http://sequelqb.blogspot.com/2011/04/error-handling-in-sql-server-2005.html
SQL Server Question Bank. For on-the-job routines, certifications, interviews . Tuesday, April 19, 2011. Error Handling in SQL Server 2005. The following code represents a basic TRY…CATCH construct. ERROR MESSAGE ();. The following error functions can be used inside a TRY…CATCH construct to get the information about the error that is occurred. ERROR NUMBER() returns the error number. ERROR SEVERITY() returns the error severity. ERROR STATE() returns the error state number. TRY…CATCH with RAISERROR. The f...
sequelqb.blogspot.com
SQL Server Question Bank: April 2011
http://sequelqb.blogspot.com/2011_04_01_archive.html
SQL Server Question Bank. For on-the-job routines, certifications, interviews . Tuesday, April 19, 2011. SQL Server 2005 Mainstream support Ended. The Microsoft SQL Server 2005 Mainstream support has ended by 12-April-2011. Therfore the certification exams associated with the product will also be expired. So please note that all the Microsoft SQL Server 2005 exams are scheduled to retire on June 30, 2011. Choose from the following three MCITP certifications on SQL Server 2005. MCTS: SQL Server 2005.
wisdom-soup.com
DBA Scripts | Wisdom-Soup
http://www.wisdom-soup.com/blog/category/dba-scripts
Share SQL Server Tips and Tricks and Related News. Category Archives: DBA Scripts. How to: Verifying CPU Pressure via Signal Wait Time. Use the following query to verify the CPU pressure via signal wait time through MS SQL Server Management Studio. USE master GO SELECT SUM(signal wait time ms) AS TotalSignalWaitTime , ( SUM(CAST(signal wait time ms AS NUMERIC(20, 2) ) / SUM(CAST(wait time ms AS NUMERIC(20, 2) ) * 100 ) AS PercentageSignalWaitsOfTotalTime FROM sys.dm os wait stats. And tagged cpu pressure.
wisdom-soup.com
Troubleshooting | Wisdom-Soup
http://www.wisdom-soup.com/blog/category/troubleshooting
Share SQL Server Tips and Tricks and Related News. Unable to Drop Windows Login from SQL Server due to ENDPOINT Permission. While we tried to drop one of our Windows Login from SQL Server, part of our house-keeping task, and SQL Server prevent us from dropping the Windows Login even though we have unmapped all the database mapped and owned by the login. It works fine for us before this. Msg 15173, Level 16, State 1, Line 2. But our SQL Server was not configured with mirroring. This entry was posted in SQ...
wisdom-soup.com
SQL Server Security | Wisdom-Soup
http://www.wisdom-soup.com/blog/category/sql-server-security
Share SQL Server Tips and Tricks and Related News. Category Archives: SQL Server Security. Unable to Drop Windows Login from SQL Server due to ENDPOINT Permission. While we tried to drop one of our Windows Login from SQL Server, part of our house-keeping task, and SQL Server prevent us from dropping the Windows Login even though we have unmapped all the database mapped and owned by the login. It works fine for us before this. Msg 15173, Level 16, State 1, Line 2. To obtain the mirroring endpoint name.
wisdom-soup.com
Unable to Drop Windows Login from SQL Server due to ENDPOINT Permission | Wisdom-Soup
http://www.wisdom-soup.com/blog/troubleshooting/unable-drop-windows-login-sql-server-due-endpoint-permission
Share SQL Server Tips and Tricks and Related News. Unable to Drop Windows Login from SQL Server due to ENDPOINT Permission. While we tried to drop one of our Windows Login from SQL Server, part of our house-keeping task, and SQL Server prevent us from dropping the Windows Login even though we have unmapped all the database mapped and owned by the login. It works fine for us before this. Msg 15173, Level 16, State 1, Line 2. But our SQL Server was not configured with mirroring. This entry was posted in SQ...
wisdom-soup.com
SQL Server Build Version
http://www.wisdom-soup.com/blog/sql-server-version
Share SQL Server Tips and Tricks and Related News. This list is original from SQLTeam.com website. And MS SQL Server Builds. Last updated on 24 July, 2013). You can also find the SQL Server and Updates Builds Numbers. From Microsoft TechNet website. Please visit to this page. On how to determine the version and edition of SQL Server and its components. SQL Server 2012 CU1. SQL Server 2012 RTM. SQL Server 2008 R2. SQL Server 2008 R2 SP1 CU6. SQL Server 2008 R2 SP1 CU5. SQL Server 2008 R2 SP1 CU4. SQL Serv...
zebra-man.blogspot.com
Blends With Savanna Grasses: Bucket List: USPTO
http://zebra-man.blogspot.com/2013/12/bucket-list-uspto.html
Blends With Savanna Grasses. The blogspot for all of those superheros and superheroines whose powers weren't quite enough to make it onto the pages of Marvel or DC. Friday, December 06, 2013. I get a lot of ideas. Some of them are even good ideas. And some of those are even good enough to turn into a product. Consequently, I've spent a little bit of mental energy over the years learning about how you'd go about filing for a patent. Posted by Zebraman @ 6:14 AM. Comments: Post a Comment. Ra-Ra for Ray Ray.
zebra-man.blogspot.com
Blends With Savanna Grasses: Dublin fun
http://zebra-man.blogspot.com/2013/07/dublin-fun.html
Blends With Savanna Grasses. The blogspot for all of those superheros and superheroines whose powers weren't quite enough to make it onto the pages of Marvel or DC. Friday, July 05, 2013. II always enjoy speaking in Dublin. My goal for next year is to do a multi-city tour. That's me and my good friend, Aaron Bertrand. Posted by Zebraman @ 10:00 AM. Comments: Post a Comment. Nashville, Tennessee, United States. View my complete profile. Ra-Ra for Ray Ray. Joe, My Duck-shootin' Buddy.
zebra-man.blogspot.com
Blends With Savanna Grasses: Little Em Sings Twinkle
http://zebra-man.blogspot.com/2013/03/little-em-sings-twinkle.html
Blends With Savanna Grasses. The blogspot for all of those superheros and superheroines whose powers weren't quite enough to make it onto the pages of Marvel or DC. Tuesday, March 19, 2013. Little Em Sings Twinkle. Emily was just 3 yrs old at the time. So cute! Posted by Zebraman @ 9:48 AM. Comments: Post a Comment. Nashville, Tennessee, United States. View my complete profile. Ra-Ra for Ray Ray. Joe, My Duck-shootin' Buddy. Darren Mallette, Strong Man. Heather, International Woman of Mystery.
SOCIAL ENGAGEMENT