Security Questions: SQL Agent Permissions
As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...
2013-06-12
633 reads
Building an Effective Data Warehouse Architecture Presentation
I will be presenting the session “Building an Effective Data Warehouse Architecture” this Thursday, June 13th at 11:00am EST for Pragmatic Works. Below is...
2013-06-12
938 reads
Building a SharePoint 2013 BI Demo Environment Part 10 – Creating a BI site
In the final part of this series, we will create a BI subsite in our site collection. You can use...
2013-06-12
3,084 reads
Best practice recommendations for writing Dynamic SQL
Note this is not “Best Practices when USING Dynamic SQL”. These are just good habits I’ve come up with over...
2013-06-13 (first published: 2013-06-12)
5,617 reads
SQL Server Management Studio Rainbow Edition
Ever wanted to know the reason behind the Database color scheme in SQL Server Management Studio? I have always wondered...
2013-06-12
880 reads
Agile Database Administration
I first heard the word “agile <something>” about 10 years ago, I do not have profound experience to what “agile...
2013-06-12
368 reads
Agile Database Administration
I first heard the word “agile <something>” about 10 years ago, I do not have profound experience to what “agile...
2013-06-12
1,324 reads
T-SQL Tuesday #43 – Hello, Operator?
This month’s TSQL-Tuesday is hosted by Rob Farley (blog | twitter), who became a Microsoft Certified Master for SQL Server 2008 this past December (you know that elitist club that...
2013-06-12
19 reads
T-SQL Tuesday #43 – Hello, Operator?
This month’s TSQL-Tuesday is hosted by Rob Farley (blog | twitter), who became a Microsoft Certified Master for SQL Server 2008 this...
2013-06-12
1,279 reads
T-SQL Tuesday #43 Crossing the Streams
Hello Dear Reader! This post finds me back in Boston getting ready for the Pragmatic Works Performance Tuning Workshop. But...
2013-06-11
1,057 reads
Blogs
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
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...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Life hack that has worked well for me
I wrote about this several years ago but will contribute again a life hack...
Trying to make this faster using not exists
Hi I have this query that is slow during the 'not in' part of...
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