MSSQLTips.com: How to Audit SysAdmin Logins
One of the first things I tried to do when logon triggers came out with Service Pack 2 of SQL...
2008-11-14
2,551 reads
One of the first things I tried to do when logon triggers came out with Service Pack 2 of SQL...
2008-11-14
2,551 reads
Illiad has been running a series on his UserFriendly comic strip about veterans. It started on Monday and has continued...
2008-11-14
713 reads
I've been asked by a few folks whether or not I'm going to the PASS Summit. The answer is I'm...
2008-11-13
591 reads
Jason Massie called me out for a new SQL Quiz that was the diabolical idea of Chris Shaw.The gist is...
2008-11-07
1,379 reads
In addition to the reading list I'm still struggling to finish, I've always got other books partially started. Maybe that's...
2008-11-07
685 reads
I've written my first tip for MSSQLTips.com:
How to setup and use a SQL Server alias
It's a pretty simple thing to...
2008-11-05
890 reads
Speaker: Brian Kelley
Midlands PASS Chapter - November 6, 2008 Meeting
Sponsored by Red Gate Software
The Midlands PASS chapter will hold our normally...
2008-11-03
509 reads
When I came home from work tonight, there waiting on my was my copy of Professional Microsoft SQL Server 2008...
2008-11-03
1,158 reads
Auditing blank passwords in SQL Server 2005 and 2008 proves a bit more challenging than in SQL Server 2000. In...
2008-11-01
1,219 reads
Here are the two presentations from last week. On Thursday I went to Miramar, Florida and presented Fortress SQL Server....
2008-10-27
1,555 reads
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Hi everyone My SSIS package does a bulk insert of csv files into a...
Dipping my toes into the waters of Azure and of course before I get...
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc] AS SELECT Consumer_ID , Trend_Category , Bit_Trace FROM NewWorldDB.dbo.MarketTrend; GOSee possible answers