Policy Based Management and Powershell
Introduction
Policy Based Management (PBM) can be used to inform DBAs when an incorrect setting is being used on a SQL...
2017-10-04 (first published: 2017-09-26)
2,034 reads
TempDB Multiple Datafiles
Problem
Most DBAs are aware that (prior to SQL 2016) one of the most common, post installation changes that needs to...
2017-03-28 (first published: 2017-03-14)
6,020 reads
SQL Agent Permissions
Problem
I was contacted by a user asking if it was possible for his team to be able to execute specific...
2016-12-21
2,669 reads
Linked Server Security
Problem
When creating Linked Servers, security often gets overlooked. This can lead to accounts on one instance having access, sometimes with...
2016-11-11
22,448 reads
Restore through FULL backup
Problem
A common misconception that i've heard a few times around backups is that a FULL backup invalidates previous TRANSACTION LOG...
2016-10-04
339 reads
Using Logins and Certificates to evelate Permissions
Problem
A common question I get asked by SQL developers is to be able to query the sys.dm_db_index_usage_stats table to see...
2016-09-16
1,091 reads
Tempdb monitoring - Free space alert
SQL Server uses tempdb for many features, including row versioning, service broker and query execution amongst others. During the execution...
2016-07-07
3,875 reads
Recertifying SQL Server 2012 MCSE with Microsoft Virtual Academy
Do people still get certified? I don’t hear much about it in the SQL community these days so I asked...
2016-02-04
515 reads
Backup Database
One of the most important processes for a DBA is backing up and restoring a database. In its simplest form,...
2015-10-07
269 reads
TDE and Availability Groups
Caution must be exercised when mixing Transparent Data Encryption (TDE) and Availability Groups to ensure databases don't end up in...
2015-10-07
700 reads
Blogs
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Switching Schemas I
Comments posted to this topic are about the item Switching Schemas I
Enforcing Unique Customer Emails When Duplicates Already Exist
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
Question of the Day
Switching Schemas I
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers