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
- Interests: cooking, F1 grand prix, internet, mobile apps
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
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
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
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
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
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
2013-12-24
424 reads
Blogs
Monday Monitor Tips: AI Query Analysis
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
AI: Blog a Day – Day 7: Vector and Vector Databases
By Vinay Thakur
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...
Forums
would it be so terrible to install ssms on a few user desktops?
Hi, ssms is free here. I can think of other reasons to do this...
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers