Did you ever want to rename an existing connection in Azure Data Studio? Unfortunately as of today (April 2020), there is no way to modify an existing connection group or...
2020-04-28 (first published: 2020-04-16)
739 reads
I’m very happy to share that I will be speaking at the next PASS Marathon event. Here are the details of the session I will be presenting on April...
2020-03-31
13 reads
As I announced before, I had the honor to be selected as speaker for PASS Summit this year. This is a huge deal for me as data professional and...
2019-11-05
19 reads
I’m very happy to announce that this will be my second time participating as speaker at the SQL Saturday# 908 in Denver! Here are the details of the session...
2019-10-09
20 reads
I’m very happy to announce that for the first time, I will be participating as speaker at the SQL Saturday# 912 in New York City! This event will be...
2019-10-02
21 reads
I’m very happy to announce that for the first time, I will be participating as speaker at the Music City Tech 2019 in Nashville. Here are the details of...
2019-09-03
19 reads
SQL Server 2008 end of support for SQL Server 2008 is fast approaching, so it’s time to take flight and build your migration plan. As announced during the...
2019-06-24
32 reads
Availability groups (AG’s) is one of my favorite features of SQL Server, despite some DBA’s catalogue them as “too complex” to implement, configure, manage and maintain … I just...
2019-05-13 (first published: 2019-05-01)
760 reads
I’m very happy to announce that for the first time, I will be participating as speaker at the SQL Saturday# 830 in Colorado Springs Here are the details of...
2019-04-05
59 reads
dbatools is a very well known tool within the SQL Server community, and probably most of the production DBA’s are...
2019-04-04 (first published: 2019-03-18)
2,381 reads
By HeyMo0sh
One of the biggest challenges I’ve faced in cloud operations is maintaining clear visibility...
By Steve Jones
I come to Heathrow often. Today is likely somewhere close to 60 trips to...
By Brian Kelley
If your organization is spending money, then meaningful results are a must. Pen testing...
Comments posted to this topic are about the item Restoring On Top II
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Comments posted to this topic are about the item Breaking Down Your Work
I have a database, DNRTest, that has a number of tables and other objects in it. The other day, I was trying to mock up a test and ran this code on the same server:
-- run yesterday CREATE DATABASE DNRTest2 GO USE DNRTest2 GO CREATE TABLE NewTable (id INT) GOToday, I realize that I need a copy of DNRTest for another mockup, and I run this:
-- run today USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO RESTORE DATABASE DNRTest2 FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens? See possible answers