How To Be An Expert At What You Do
Every successful company has them. They’re the lifeblood of their organisations. Linchpins essential to getting things done and doing them...
2013-03-20
1,049 reads
How I used Data Explorer to create a demo
Some time ago Data Explorer, an add-in for Excel 2010 or 2013, was released in Public Preview. In short, it...
2013-03-20
846 reads
PowerShell Usage in DBA Work – Case Study 5/7
One challenge in a super-multiple server (say a few hundred servers) environment is to know what sql services (SSRS/SSAS/SSIS/Engine/Agent etc)...
2013-03-20
1,025 reads
Retrieve unsaved query
I was working on a remote machine and while I was away, the machine was restarted. Lost the scripts I...
2013-03-20
129 reads
Consuming News Through Social Media and Read It Later With Pocket
These days the fastest way, not always the most accurate, to get news is through social media. Technology, sports, politics,...
2013-03-20
1,097 reads
Remove duplicate records from a table in SQL server
Here I create a table and
inserted some duplicate records for testing purpose.
createtable temp(cust_id varchar(50))insertinto temp(cust_id)values('oms1'),('oms2'),('oms1'),('oms2'),('oms3')select*from temp
Method 1: (You can simply...
2013-03-19
3,844 reads
SQL Server 2012: Indirect Checkpoint (Target Recovery Time), get the real scoop
SQL Server 2012 brings a new feature called Indirect Checkpoint. You can read more about it here: http://msdn.microsoft.com/en-us/library/ms189573.aspx. With Indirect Checkpoint, you get smaller and too many I/Os Checkpoint...
2013-03-19
30 reads
SQL Lunch – Power View Against Multidimensional Models
It has been some time since I have hosted or presented on the SQL Lunch. Work and home life is...
2013-03-19
1,326 reads
SQL Server DMV: sys.dm_exec_requests
Today, I’ve received an email from friend asking that that is there any way to find out the progress of...
2013-03-19
1,679 reads
Speaking Tomorrow Night at MagicPASS
I’ll be driving south a few miles tomorrow night to talk to the great group at MagicPASS about the basics...
2013-03-19
654 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