SSMS and scripting
I've heard a lot of complaints about SQL Server Management Studio concerning slowness and some of the things, like scripting...
2006-11-28
1,368 reads
Kathi Kellenberger
- Interests: Walking, running, grandchildren!
Default schema
Sadly, I haven't had much experience yet with SQL Server 2005 except for Reporting Services and SSIS. The majority of...
2006-11-27
1,399 reads
Back from PASS
While at PASS, I created a thread in the forums: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=61&messageid=322277 . It was an incredible week. I look forward to...
2006-11-20
1,310 reads
PASS
My daughter-in-law just reminded me on Sunday that her birthday was in 21 days. Yikes! That's the day I fly...
2006-10-26
1,314 reads
Writing Simple Select Statements - Part 3
In this video, Kathi continues her T-SQL series and exands how to use the WHERE clause.
2006-10-26
3,469 reads
Writing Simple Select Statements - Part 2
In this second part video from Kathi, she covers how to write T-SQL in much more indepth. She covers how to handle NULLs and many more items in this video.
2006-10-12
2,787 reads
Writing Simple Select Statements
In this video, you'll learn how to write basic select statements. This beginner video takes you from the ground up writing T-SQL.
2006-10-04
3,402 reads
Jumpstart TV Video
If you are new to SQL Server, you might be interested in viewing a video that covers the terms you use...
2006-09-11
1,583 reads
RegCreateKeyEX() error
I just began migrating SQL Servers (2000) to Windows 2003 from Windows 2000 a few months ago. In the past, I...
2006-03-27
2,934 reads
PASS 2006 Call for Presentations
For those of you who are interested in speaking at PASS in November, the submission site is open: http://passew.prod.web.sba.com/callpapers/CallPapers.cfm?conference_id=15 .
I encourage...
2006-02-09
1,304 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
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
Restoring On Top I
Comments posted to this topic are about the item Restoring On Top I
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