Mo-SQL On A Stick
If you’re involved in the database world it’s hard to have missed the rise of the “no-sql” database products, designed...
2013-04-01
1,025 reads
SQL Server – Saving Changes Not Permitted in Management Studio
SQL Server Management Studio does not allow you to save changes to a table which require table re-creation such as...
2013-04-09 (first published: 2013-04-01)
3,446 reads
DMV-3 : What is currently going on ?……..sys.dm_exec_requests
sys.dm_exec_requests DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms177648.aspx
Returns information about each request that is executing within SQL...
2013-04-01
1,205 reads
Custom Reports for SSMS 2012
I presented on this topic at the TriadSQL User’s Group meeting on 3/26/13. I promised I would post my code/solutions,...
2013-03-29
2,157 reads
SQLServer Log Shipping Work File ! What is this all about ?
A short and sweet post for a gorgeous morning -
Have you seen a file with extension .wrk in the log shipping copy folder...
2013-03-29
4,283 reads
Exploring Excel 2013 for BI Tip #5: Cleaning Up Slicers
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2013-03-29
1,605 reads
Reblog: March 22 to March 28
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-03-29
1,462 reads
Free SQL Server Training for the Week of April 1, 2013
Here are some training events you might be interested in for the coming week:
Tuesday, April 2
11:00-12:00 EDT, Introduction to SQL...
2013-03-29
1,600 reads
Is BETWEEN faster than GTE and LTE?
I know I have been light on blog posting this year. They always say that life tends to get in...
2013-04-04 (first published: 2013-03-29)
32,775 reads
SSPI error and Incorrect timing.
TweetG’day,
Recently, quite out of the blue I started seeing this error when I tried to log into my SQL instance...
2013-03-28
1,670 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