Remembering Alan Weber, @Aauugold
We lost someone this week. We lost a fellow SQL-ite, a Twitterer, a DBAs@Midnight chatroom live chatter. We lost someone...
2013-04-05
842 reads
Use delegated session configuration in Powershell 3.0
Powershell 3.0 has many new feature, and they are useful in some circumstance.
let's say User A log in server A,...
2013-04-05
1,213 reads
Weekly Links – 05/04/2013
I’m starting a new tradition:
Before each weekend, I will post links to the best SQL Server stuff i’ve read, heard...
2013-04-05
1,035 reads
Don't Alienate Your Customer
This should go without saying, because most of us have been on the receiving end of poor customer support. However,...
2013-04-05
1,039 reads
Time Based Power Settings
Just recently I was part of an online presentation in which the intended audience was unable to install any of...
2013-04-04
238 reads
The PUBLIC role – Do not use it for database access!
As per Microsoft Books Online and SQL Server Security best practice white paper, it is recommended to periodically review privileges...
2013-04-04
4,897 reads
Windows Azure SQL Database Backups
You can get backups of your WASD databases. But, if you want them to be transactionally consistent, you need to...
2013-04-04
926 reads
SQL Server Events in the UK – April 2013
The bank holiday and work have put me a few days behind schedule, but here is the list out all of the...
2013-04-04
750 reads
How I prepared myself for the MCSE certification
Last week I took the final exam to acquire the MCSE – Business Intelligence certification. This blog post describes my preparation...
2013-04-04
18,498 reads
Ask the Expert Panel: NJ Special Event
Ever wanted to know all there is to know about SQL Server, and afraid to ask? Have questions about how...
2013-04-04
1,219 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers