Logins vs Users
Logins are not Users. It’s a pretty easy concept but one that seems to give a lot of people problems....
2012-12-12 (first published: 2012-12-03)
3,645 reads
Logins are not Users. It’s a pretty easy concept but one that seems to give a lot of people problems....
2012-12-12 (first published: 2012-12-03)
3,645 reads
I’m in the middle of reading a good book on DMVs, “SQL Server DMVs in Action” http://www.manning.com/stirk by Ian W....
2012-11-30 (first published: 2012-11-26)
4,595 reads
The other day I was writing a query to pull some DMV information and I ended up using several CTEs...
2012-11-20
1,964 reads
Over the last couple of weeks I’ve set up a SSIS package that will loop through a group of servers...
2012-11-15
2,722 reads
I’ve been working on a way to test performance usage on a server by database. I started out using sys.dm_exec_query_stats...
2012-11-12
1,695 reads
Last week I posted a quick example of looping through multiple servers using SSIS and being in a bit of...
2012-11-12 (first published: 2012-11-09)
2,763 reads
About three years ago my manager came up to me and said “We need someone to learn SSIS, you’re it.” ...
2012-11-07
1,173 reads
This is just a quickie post to answer a question on how to loop through multiple servers in SSIS. There...
2012-11-05 (first published: 2012-10-31)
4,928 reads
Many years ago when I was still working on SQL 2000 I occasionally needed to find all stored procedures and views...
2012-10-26
9,967 reads
Every now and again (today for example) I’ll get a call that one of our SQL Server instances is down. ...
2012-10-23
1,248 reads
By Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
Say we have a database that we want to migrate a copy of into...
We are trying to get apps and users off of using SQL accounts to...
Hi I have this view to check if a job is running: SELECT...
All, if you are like me and do not care for the built-in color...
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers