Capture Important Parameters of the SQL Server Replication
Whenever there is a business requirement to add a new article to an existing publication, you want to know how...
2017-07-13 (first published: 2017-07-03)
1,721 reads
Blog Posts
My Evening With SQL Tool Service
Hello!
I’ve been writing a PowerShell Module that will handle deploying SQL Server Agent Jobs by using the Agent namespace in...
2017-07-13
251 reads
No, Binary Collations are not Case-Sensitive
Quite often people will use, or will recommend using, a binary Collation (one ending in “_BIN” or “_BIN2“) when wanting...
2017-07-13
2,162 reads
The Three A’s: Auditing
Authentication and Authorization, the first two of the three A’s of security, control who gets access to what. However, at...
2017-07-13 (first published: 2017-06-28)
1,634 reads
Be Wary of Date Formatting in T-SQL
Today’s public service announcement is a reminder to be wary of date formatting in SQL Server. On a recent mailing...
2017-07-12
164 reads
I’m Speaking! Evansville Technology Group
SQL Server user group is a backbone of the SQL Server community. I currently help run the Louisville SQL Server...
2017-07-12
128 reads
I’m Speaking! Evansville Technology Group
SQL Server user group is a backbone of the SQL Server community. I currently help run the Louisville SQL Server...
2017-07-12
461 reads
LocalDB DSC Script
Hello!
So, there are many different product SKUs of SQL Server available, and generally when developing it’s probably best to use...
2017-07-12
299 reads
Row-count Estimates when there are no Statistics
I was discussing Cardinality Estimation with a colleague recently and the question came up, what cardinality does SQL Server use...
2017-07-12 (first published: 2017-06-28)
2,901 reads
SSRS Report Deployment Made Easy – 700 times Faster
Back in October 2016, Microsoft started a new GitHub repository – ReportingServicesTools – an open source PowerShell module to manage SQL Server...
2017-07-12
3,959 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...
Trying to make this faster using not exists
Hi I have this query that is slow during the 'not in' part of...
Switching Schemas I
Comments posted to this topic are about the item Switching Schemas I
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