Presenting for the new PASS Security Virtual Chapter on July 18
The PASS Security virtual chapter is up and running thanks to the hard work of Argenis Fernandez (blog | twitter) and...
2013-07-17
1,275 reads
SQL Server: Performance Tuning :Understanding Set Statistics IO output
Performance tuning is one of the important task of DBA. Many times people comes to us with different types of performance issue.To handle all these, we should have...
2013-07-17
61 reads
SQL Saturday 232 Schedule is LIVE!
Hello Dear Reader! Just a quick blog post today. The Schedule for SQL Saturday 232 is now live! You probably...
2013-07-16
556 reads
SQL Server: Performance Tuning :Understanding Set Statistics IO output
Performance tuning is one of the important task of DBA. Many times people comes to us with different types of...
2013-07-24 (first published: 2013-07-16)
4,029 reads
The benefit of placement firms
Why do companies use placement firms to find IT contractors instead of using internal recruiters?
Who better to answer that question...
2013-07-16
803 reads
How to share redgate database tools settings with Team Foundation Service
In a previous post we’ve seen how to share the SQL Prompt snippet folder to the development team. We’ve used dropbox for sharing...
2013-07-16
1,020 reads
SSMS 2012 Extender for the times you want some organization to the random pile of objects gathering in the dusty confines of that database
When dealing with large amounts of objects in a database, navigation can be tedious with SSMS object explorer. This extender...
2013-07-16
749 reads
Data Visualization – Book Review
To prepare myself for my session Data Visualization Tips & Tricks, I read a few books. In this blog post, I’ll...
2013-07-16
1,111 reads
Setup an Availability Group with Multiple Subnets in VMware Workstation
Before we get started, I want to make it clear this is NOT how you would normally configure all these...
2013-07-16
2,548 reads
70-457 Reviewer #03, Planning an Installation of SQL Server 2012
Planning an installation on SQL Server 2012 is under the Install and Configure SQL Server objective which is 19% of...
2013-07-16
667 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