Moving Day
When you upgrade to a new server, there's more than just making sure that everything is ready to move, but do you clean house? Do you ever go back and ensure you're not moving things that you don't need?
2009-09-17
107 reads
When you upgrade to a new server, there's more than just making sure that everything is ready to move, but do you clean house? Do you ever go back and ensure you're not moving things that you don't need?
2009-09-17
107 reads
The SQL Connections conference will be held this November in Las Vegas and Steve Jones is attending. See what he's interested in viewing at the event.
2009-09-16
126 reads
Most of us learn on the job, but is that the best way? If you could learn faster at a cost, would you pay it? Steve Jones talks a little bit about what he has done and what he would do today in today's editorial. What is a SQL Server education worth to you?
2009-09-15
153 reads
Microsoft's new server lab building will house 35,000 servers. That's a lot of computing power, and it's being done in a greener fashion.
2009-09-14
83 reads
Should you buy or build a monitoring system for your SQL Server? Todays' guest editorial from Grant Fritchey talks about the resistance to recommendations that many people seem to have.
2009-09-14
991 reads
Moore's Law has been in the front of technical people's minds for years. However is the end of it's applicability to our world near? This Friday Steve Jones asks if you pay attention to the news about processor hardware.
2009-09-11
155 reads
A guest editorial from Phil Factor puts in a good word for ODBC. This is the standard for Windows machines to connect to all kinds of data sources, and is both loved and hated by developers of all kinds.
2009-09-10
319 reads
There was a vulnerability announced in the SQL Server password system last week, but Steve Jones doesn't see this as much of an issue. Read his thoughts and see if you agree.
2009-09-09
227 reads
What's the best driver for your server? What's the best of anything? Steve Jones talks about how the experts determine this, and why there is no easy answer.
2009-09-08
95 reads
Rodney Landrum has lived through several simulated emergencies and one real one, in the form of Hurricane Ivan. The tests do not adequately prepare you for the real thing. Real emergencies bring tension, exhaustion and hunger pangs. Simulations bring lethargy, pre-determined end times, and warm pizza.
2009-09-07
179 reads
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
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