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...
insanesql.blogspot.com
Sql Server Insane Asylum: February 2010
http://insanesql.blogspot.com/2010_02_01_archive.html
Sql Server Insane Asylum. Information about SQL Server from the Asylum. Tuesday, February 9, 2010. Speaking at the User Group. Last night was the first time I’ve spoken to the user group in quite some time. I’m posting this up so I avoid some of the mistakes I made last night. I was out of practice so I made some simple mistakes. . Links to this post. Friday, February 5, 2010. DBA Survivor Caption Contest. Thomas Larock aka @SqLRockstar ( Blog. 8220;I hope those zombies aren’t coming for me”. 8220;This...
ozar.me
What’s the Difference Between Contractor and Consultant and FTE?
https://ozar.me/2015/06/whats-difference-contractor-consultant-fte
What’s the Difference Between Contractor and Consultant and FTE? June 30, 2015. Thinking about quitting your full time job and changing things up a little? Here’s a quick explanation of the differences between IT roles. Full Time Employees (FTEs) of Regular Companies. You show up for work on Monday at 8AM, and you know exactly where you’re going to work, and who you’ll be working with. You have lots of water cooler conversations with the same people every week. Consultants give advice about what the clie...
ozar.me
consulting
https://ozar.me/tag/consulting
How to Find Out if Independent Consulting is Right for You. August 23, 2016. Wanna be a freelance consultant? Wanna do the same thing you’re doing today as an employee, but on your own, getting your own clients directly? There’s an easy way to tell if you’ll be good at it: start doing it today in your full time role. Here’s how. Step 1:…. Video: How to Become a Consultant or Contractor. June 2, 2016. Our first Augusts scared the hell out of me. September 29, 2015. Were customers just not…. August 11, 2015.
sqlserverio.wordpress.com
My Tools | SQL Server Input/Output
https://sqlserverio.wordpress.com/my-tools
Skip to main content. Skip to primary sidebar. Skip to secondary sidebar. Digging deep into IO subsystems and SQL Server. Stuff that I have built over the years. SQL Server File System Tools. UBCopy, a fast C# file copy program. Iometer SQL Server IO Patterns File. Rename to .icf and open with Iometer. If you want Iometer to default to this file rename it to iometer.icf. Iommeter output parser and importer. SQLIO ToolSet used for generating batch files and parsing the results. February 22, 2012 at 3:24 am.
chrisyatessql.wordpress.com
Chris Yates | The SQL Professor
https://chrisyatessql.wordpress.com/author/cyates04
Author Archives: Chris Yates. Are SQL Saturday’s Worth It? This past weekend I was fortunate enough to be a part of Louisville’s (for those local the ‘ville) SQL Saturday event held at Indiana Wesleyan. Most of you who end up on this site are probably familiar with it, but for those that aren’t familiar with SQL Saturday events you can check out their site here. Now to…. 1 week ago August 12, 2016. T-SQL Tuesday #080–Round Up. July 19, 2016. T-SQL Tuesday time is here again! July 6, 2016. June 29, 2016.
SOCIAL ENGAGEMENT