Putting a Database into Single User Mode
I was recently discussing with a group of budding DBA’s how you go about performing a restore of database. They...
2011-08-08
1,343 reads
Gethyn Ellis
Audit SQL Logins
Written by David Postlethwaite There are several ways that you can audit who has logged in to your SQL Server. The...
2011-08-05
4,727 reads
Updating Views
Written by Ian Treasure
Gethyn recently posted on deleting from a view. He used a common situation where several tables are...
2011-08-03
10,119 reads
We Have Another New Contributor…
I’d like to introduce you all to my friend Ian Treasure who has kindly volunteered to write some posts and...
2011-08-01
605 reads
Calling SCOM in C#
Written by David Postlethwaite
I’m sure there are many out there using System Centre Operations Manager (or SCOM for short)...
2011-07-29
3,951 reads
Searching for Wild Card Characters
I got asked an interesting question recently, I was demonstrating how you can use wild cards in a WHERE clauses...
2011-07-27
768 reads
IT Professionals, the Job Search and the Killer CV
It has been while since I wrote anything on my contracting blog but over the past month or so I...
2011-07-25
1,205 reads
SSRS: Dynamic Data Sources
I have been building dashboard using Reporting Services (SSRS) for a client of mine. The dashboard is going to be...
2011-07-22
7,956 reads
DOS Batch File Date and Time
Written by David POstlethwaite
A non SQL blog for a change
Ever needed to create a batch file that wrote a time...
2011-07-20
1,365 reads
Execute Permissions
Written by David Postlethwaite
Security of the SQL database is becoming more and more important these days yet I’m finding that...
2011-07-18
13,715 reads
Blogs
SQL Server Alerts
By Kevin3NF
Don’t Let Trouble Sneak Up on You Most SQL Servers run quietly. Until...
Prompt AI helping with Auditing
By Steve Jones
I had a conversation with a customer asking this question: how can I tell...
From Data Custodian to Innovation Catalyst: The Evolving Role of the CDO
By Chris Yates
There was a time when the Chief Data Officer lived in the shadows of...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Was the index created or not?
Hi everyone I am getting an error when I create the index but I...
SSIS Package is reporting successful however is short 80-100k records
Good morning all, I have been running into a very random weird issue that...
Question of the Day
Estimated Rows
I have two calls to the GENERATE_SERIES TVF in this code:
SELECT TOP 10 gs.value FROM GENERATE_SERIES(1, 10) AS gs ORDER BY NEWID () OPTION (RECOMPILE); go DECLARE @a int = 10; SELECT TOP (@a) gs.value FROM GENERATE_SERIES(1, @a) AS gs ORDER BY NEWID () OPTION (RECOMPILE);In the actual query plans, what is the estimated number of rows for each batch in SQL Server 2022? See possible answers