April 2013 – Monthly SQL Server Checklist
After working on this monthly checklist for over a year, I’ve recently discovered that there isn’t anything that we should...
2013-04-01
551 reads
UNPIVOT a table using CROSS APPLY
I generally spend part of each day looking through http://www.stackoverflow.com, http://dba.stackexchange.com or http://www.sqlservercentral.com. I read through questions that have already...
2013-04-12 (first published: 2013-04-01)
4,204 reads
Last Weeks Top “Reading” Links #26
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-04-01
450 reads
Setup SSL Access to SSRS 2012 with Active Directory Certificate Services
The objective was to configure SSL access to a SQL 2012 Reporting Services server in Native Mode. The Certificate Issuer...
2013-04-01
12,459 reads
SQL Server Analysis Services Webinar
Join me tomorrow, April 2. 2013, at 11:00 PM EST for a free webinar which is part of an entire...
2013-04-01
870 reads
Mo-SQL On A Stick
If you’re involved in the database world it’s hard to have missed the rise of the “no-sql” database products, designed...
2013-04-01
1,033 reads
SQL Server – Saving Changes Not Permitted in Management Studio
SQL Server Management Studio does not allow you to save changes to a table which require table re-creation such as...
2013-04-09 (first published: 2013-04-01)
3,456 reads
DMV-3 : What is currently going on ?……..sys.dm_exec_requests
sys.dm_exec_requests DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms177648.aspx
Returns information about each request that is executing within SQL...
2013-04-01
1,222 reads
Custom Reports for SSMS 2012
I presented on this topic at the TriadSQL User’s Group meeting on 3/26/13. I promised I would post my code/solutions,...
2013-03-29
2,167 reads
SQLServer Log Shipping Work File ! What is this all about ?
A short and sweet post for a gorgeous morning -
Have you seen a file with extension .wrk in the log shipping copy folder...
2013-03-29
4,289 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