12-inch grass stem?
Those of us in technology are very, very used to automated systems,
batch jobs, etc., all which run without human interaction...
2006-03-29
1,354 reads
Blog Posts
Internet Explorer Vulnerability
If you're using Internet Explorer, be advised Microsoft has released a
security advisory for Internet Explorer. This would allow an attacker
to...
2006-03-28
1,559 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
Is Documentation Dying?
The BOL for SQL Server 2005 has been interesting to read. On one hand there is a more comprehensive approach...
2006-03-24
1,513 reads
Blue Hat
Microsoft had their Blue Hat security conference recently, inviting hackers to take their shots at the Microsoft products. Mostly security...
2006-03-16
1,556 reads
Rights within the database
This is a follow-on to my post What are the actual rights?
First and foremost, I want to include membership in...
2006-03-14
1,418 reads
What are the actual rights?
One of the things I've started to work on are some scripts to quickly
be able to pull what a user's...
2006-03-14
1,447 reads
First Impressions of Professional SQL Server 2005 Integration Services
I received a copy of Professional SQL Server 2005 Integration Services
a few weeks back from Kathi. Because of illness and...
2006-03-13
1,482 reads
Tool Updates
Catching up on recent updates for tools I've looked at and/or recommended.
SQL Server Tools:
PromptSQL is now up to version 1.4....
2006-03-13
1,567 reads
Microsoft MVP Program
I think anyone who posts actively in the various on-line forums for
Microsoft products (such as SSC.com) hopes one day to...
2006-02-23
1,372 reads
Blogs
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
AI: Blog a Day – Day 2: Generative AI, Multimodal Systems, and Agent AI
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers