Local Database Issues
Steve Jones talks about the issues with using a local database in your application.
2016-11-14
72 reads
Steve Jones talks about the issues with using a local database in your application.
2016-11-14
72 reads
2016-11-11
165 reads
2016-11-10
128 reads
Today we have a guest editorial from Ben Kubicek as Steve is away from the office. It is hard to be humble, but it is needs to learn something new.
2019-11-27 (first published: 2016-11-07)
476 reads
ODBC is the closest thing we have to a universal standard for data access across platforms, applications and data sources. So why doesn't DocumentDB support it?
2016-11-07
116 reads
This week Steve Jones has a bit of a competition. Share with him how fast you can back up a 1TB database.
2016-11-04
209 reads
Today Steve Jones looks at the relative cost of hardware and how we sometimes cause ourselves issues by not spending enough.
2019-12-20 (first published: 2016-11-03)
270 reads
We depend on data quality to run our businesses efficiently. However, it's a problem when we mess that data up on purpose.
2016-11-02
82 reads
The differences in our understanding of technologies can make for some communication challenges.
2020-11-05 (first published: 2016-11-01)
168 reads
The release of Analysis Services in Azure means the platform has a future.
2016-10-31
71 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