Developer’s Life – Every Developer is a Spiderman
Originally posted on Journey to SQL Authority with Pinal Dave:
I have to admit, Spiderman is my favorite superhero. The most...
2014-05-17
781 reads
Coffee and SQL
Data Collection in SQL Server
Problem : As a DBA, one of your primary job description is to handle management and administration of 1 or 100+...
2014-05-11
868 reads
That “Cannot Generate SSPI Context” headache
Problem : You have completed an SQL Server setup on a new instance. The setup is successful, you can connect locally...
2014-05-10
1,521 reads
Allowing your App team to run SQL Agent Jobs
Problem : In most of your projects, there is always that situation that the application team have that need to run...
2014-05-10
667 reads
SQL Agent Error During Windows Failover Cluster Setup
Problem: You had just finished up installing cluster setup in your Primary node. After verifying your setup is complete and...
2014-04-27
811 reads
Cumulative Update #16 for SQL Server 2008 SP3
Here’s a link for the download for the CU #16 for SQL2008 SP3 http://blogs.msdn.com/b/sqlreleaseservices/archive/2014/03/17/cumulative-update-16-for-sql-server-2008-sp3.aspx. The post also includes all the previous...
2014-03-31
1,277 reads
Understanding CXPACKET wait stats in SQL Server
Understanding CXPACKET From the SQL BOL (Books on Line) CXPACKET is defined as Class Exchange Packet and “occurs when trying...
2014-01-21
1,246 reads
Understanding the Copy_Only option in Backups for SQL Server
The Copy_Only option is very useful in full backup scenario when you don’t want to break up the sequence of...
2014-01-08
1,060 reads
Reviewer #17 Database Replication in SQL Server 2012
Wow, my first article for the year 2014! Here’s to a blessed and fruitful year ahead for all of us...
2014-01-08
692 reads
HOW TO Set up TEST Environment for SQL SERVER 2014 CTP2 or SQL SERVER 2012 PART 2
Originally posted on SQL DBA learning curve:
Hi ALL, for setting up TEST env for Server 2012 and above refer to...
2013-12-24
708 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers