Foundations Friday starts now
Earlier this month, my friend Tim Ford (b|t) proposed an idea:
A 2016 challenge to technical bloggers: 1 introductory level blog...
2016-01-21
451 reads
Earlier this month, my friend Tim Ford (b|t) proposed an idea:
A 2016 challenge to technical bloggers: 1 introductory level blog...
2016-01-21
451 reads
I worked in an Agile team in 2000 and we deployed changes to our web platform every Wednesday for over...
2016-01-21
534 reads
Rule "Microsoft .NET Framework 3.5 Service Pack 1 is required" failed.
This is a common problem and relatively easy fix for...
2016-01-27 (first published: 2016-01-21)
1,511 reads
Recently I got my hands on a copy of Extending SSIS with .NET Scripting, written by SQL Server MVP Joost...
2016-01-29 (first published: 2016-01-21)
2,868 reads
There are many many blog posts out there about Virtual Log Files (VLFs) - one of the absolute best is "8...
2016-01-21
878 reads
Thought I would share a note that I received from Nick Landry, Sr. Technical Evangelist for NY Metro & NJ, about...
2016-01-21
1,263 reads
RapidMiner Overview
If you are searching for a data mining solution be sure to look into RapidMiner. RapidMiner is an open...
2016-01-21
580 reads
Transaction Logging & Recovery (part 3)
… Continuation of some notes regarding the excellent content by Paul Randal in *Pluralsight: SQL Server:...
2016-01-20
840 reads
One of the more underused features of Power BI is the Google Analytics data source. Working closely with marketers and...
2016-01-20
1,325 reads
This post is designed to explain the installation steps of some of the new features in 2016 and just how...
2016-01-20
789 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
Comments posted to this topic are about the item Switching Schema II
Comments posted to this topic are about the item A Practical Approach to Automating...
Comments posted to this topic are about the item Data Lost in the Cloud
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 two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers