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
771 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
857 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,516 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
660 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
806 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,269 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,240 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,054 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
682 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
703 reads
Blogs
Creating a GitHub Actions Self-Hosted Runner
By Steve Jones
I had to demo the Flyway Autopilot system recently and created a GitHub Actions...
Migrating from Azure PG Single Server to Flex with Azure VM and pg_dump/restore
This is more complicated than using the Azure Migration method, but because it’s maxed...
PowerShell (and T-SQL) and Elastic Jobs
I’ve covered how to create Elastic Jobs in the portal (this one is important...
Forums
Avoiding duplicates stop and restart an ssis package that is using batch inserts
Hi, I an using VS 2022 to build a package that selects and then...
Contracting DBA - Permissions for initial analysis
Accidental DBA here. After looking at all the work that needs to be done,...
How to convert run_date and run_time columns to datetime from SQL Agent systable
Hello SSC, Hope you are all having a great Monday! I am trying to...
Question of the Day
AG Rules for Databases
Which of these is not a requirement for a database to be added to an Availability Group (AG)?
See possible answers