Determining Active Directory Group Membership
As discussed in my previous post I prefer to use Windows authentication over SQL authentication on my SQL Servers. There...
2012-01-24
1,714 reads
SQL Server 365
Security - SQL vs Windows
Security is a very important part of every DBA’s role. If you are not clued up on security best practices...
2012-01-23
937 reads
Database uplevel Restores Follow On
Today's post is a follow on from one earlier this month Database uplevel Restores. I got round to testing restoring...
2012-01-20
1,140 reads
Don’t Be a Balloon!
I had a problem just before the festive period where one of our production SQL Servers was randomly grinding to...
2012-01-18
1,715 reads
Moving Database Files and Replication
Today’s post is a quick one as I am a bit under the cosh.
There are many ways to move database...
2012-01-13
682 reads
System Stored Procedures
I've been using 4 alerts for corruption now for about 2 years for Errors 823, 824, 825 and 9100. Basically...
2012-01-11
1,037 reads
Server Name and SQL Server Name
I have, in the past had the need to rename a server, either because the server has been named incorrectly...
2012-01-10
775 reads
Database uplevel Restores
Today I've been reading Paul Randal's collection of Blogs from a series called A SQL Server DBA myth a day....
2012-01-06
685 reads
SQL Server Error Logs
I read a blog post this morning on SQLServerCentral by Tim Radney about SQL Server Error Logs. Tim talks about...
2012-01-04
1,074 reads
Dropping a Database
I came across an issue on a server this morning where a drive had run out of free space. Now given...
2012-01-03
614 reads
Blogs
The CDO’s Playbook for AI Driven Decision Making
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
sp_snapshot – The easy way to take database snapshots of one or more databases – V3.0
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
SELECT *
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth,...
Forums
combining a param value with widcards in a foreach loop files property
Hi, it isnt clear from the web if something like this should work as...
Extract sql data in psh
# Load ImportExcel module Import-Module ImportExcel -ErrorAction Stop # File paths $outFile = "C:\Reports\SQLReport.xlsx"...
caught off guard by some greek lettering in a warehouse feed
Hi we run 2019 standard. Our warehouse's ssis based etl is klunky but so...
Question of the Day
Vector Datatype
The new Vector datatype in SQL Server 2025 is a binary type that has a few parameters. What parameters are required?
See possible answers