Where is my backup?
We recently added responsibility for ~80 more servers to our team. This means that my team-mates and I are working...
2012-12-19 (first published: 2012-12-12)
2,019 reads
Kenneth Fisher
Generating multiple SQL statements from a query
Dynamic SQL is one of my favorite tools in the DBA toolbox. I’m big on automation and dynamic SQL can...
2012-12-17
1,126 reads
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
Copying Connection Managers in SSIS
Did you know you can copy and paste connection managers in SSIS? While I haven’t found this a huge benefit...
2012-12-10
1,526 reads
Creating an empty table from a SELECT statement
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,593 reads
CTEs beyond SELECT
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
Looping through multiple servers in SSIS Part 3
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,703 reads
2012-11-15
2,036 reads
Looping through multiple servers in SSIS part 2
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,760 reads
Time Trial sys.dm_exec_query_plan vs sys.dm_exec_sql_text
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,692 reads
Blogs
Using Flyway with Feature Flags
By Steve Jones
There is a nice article at Harness.io on their use of feature flags and...
Microsoft Build event announcements on Fabric
By James Serra
There were a number of Microsoft Fabric announcements at Microsoft Build yesterday that I wanted to...
Forums
Calculating moving moving averages for different ranges in one query
I have this query, which is gives result I want (may be not, i...
Monitoring if something is deleted in DB
Hello, I have long-term task, which came one year ago, and just now I...
LOGON Trigger Count
Comments posted to this topic are about the item LOGON Trigger Count
Question of the Day
LOGON Trigger Count
I have the need in SQL Server 2022 to create a complex set of checks for logins. I want to use Longon triggers, but I'd like to separate out logic. How many Logon Triggers can I create?
See possible answers