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,118 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,708 reads
Blogs
T-SQL Tuesday #191: Invitation–Your Favorite String Parsing
By Steve Jones
It’s that time of the month, and I’m late. My apologies. I had a...
Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
Forums
The Improvement Limit
Comments posted to this topic are about the item The Improvement Limit
Migrate SSRS Reports to a New Server in Just a Few Clicks
Comments posted to this topic are about the item Migrate SSRS Reports to a...