Fargo SQL Saturday (#SQLSat175) Schedule Is This Weekend
We are down to the last few days before first SQL Saturday in Fargo. It’s been some work pulling it...
2013-04-23
507 reads
Blog Posts
Industry Expert Interview
I don’t know if I would consider myself an industry expert, but hey, it says it on the Internet, so...
2013-04-23
1,015 reads
PowerSQL – Database Backup Report across all Servers – Centralized Approach
This topic provides and describes the quickest way to find when and what databases are being backed up recently.Backups are...
2013-04-23
1,074 reads
Review of The Way
The Way, starring Martin Sheen and directed by Emilio Estevez has been on my want to watch list for a...
2013-04-23
680 reads
Service Application Architecture
Hello Friends,
As discussed in my previous blog the new architecture of Service Application in 2010. Today I am here with...
2013-04-23
902 reads
snippet designate a certain time of the day in getdate()
Snippet to designate a certain time of the day to evaluate in the current day. If you need to limit a...
2013-04-23
362 reads
Speaking at the 2013 Carolina Code Camp
On Saturday, May 4, the Enterprise Developers Guild in Charlotte will hold their annual Carolina Code Camp. There's a number...
2013-04-23
888 reads
Creating Dimension Table ==> Time (Example)
Script for Dimension table for Time.
Here Date_ID is the primary key which can be used as the foreign key...
2013-04-22
944 reads
Cumulative Update – 7 for SQL Server 2012 RTM Is Now Available !
The 7th cumulative update release for SQL Server 2012 RTM is now available. Cumulative Update 7 contains all the hotfixes...
2013-04-22
871 reads
Last Weeks Top “Reading” Links #29
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-04-22
1,037 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