Suggestions for PASS Published on SSC
I wrote this article shortly after returning from the PASS 2007 Summit and tried hard to come up with ideas...
2007-10-18
1,349 reads
I wrote this article shortly after returning from the PASS 2007 Summit and tried hard to come up with ideas...
2007-10-18
1,349 reads
All of these are new articles that have gone up on SSC recently. The troubleshooting one was my attempt to...
2007-10-14
628 reads
Bill Graziano (main man at SQLTeam.com, consultant, and VP of PASS) was in town recently to speak at both the...
2007-10-13
683 reads
I'm catching up on my reading today and ran across an article from Kathi Kellenberger called Understanding the Difference between...
2007-10-13
604 reads
I'm a couple days late updating the blog, the article went up on Mon.
2007-10-11
572 reads
Continuing on with a look at SQL Server 205 partitioning features, Andy Warren delves into archiving techniques.
2007-10-08
9,126 reads
I spent last week onsite with a client teaching performance tuning and it was really a good week. Great company...
2007-10-08
607 reads
SQL Server guru Andy Warren brings us a list of things that he considers when things go wrong. Read about some of the common sense approaches to solving performance and other problems.
2007-10-03
4,595 reads
This article by Andy warren shows you how to get started with DMO using either VB or VBScript. The article includes sample code that will backup all databases on a server and will update the statistics on all databases as well.
2007-10-02 (first published: 2003-08-15)
39,128 reads
This article by Andy Warren talks about using sp_addlogin to move logins from one server to another. It also points out a problem you may run into if you have a SQL 7 server that was upgraded from 6.5
2007-10-02 (first published: 2001-05-01)
10,935 reads
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
By Vinay Thakur
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...
Hi, ssms is free here. I can think of other reasons to do this...
I've written some documentation on using different Markdown types of files on GitHub. It's...
Comments posted to this topic are about the item Not Just an Upgrade
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