Insert data from Excel to SQL Server
Here I am discussing about data insertion from MS Excel into SQL Server table. SSMS provides Export Import wizard by...
2013-09-16 (first published: 2013-09-11)
7,259 reads
Presentation Slides for Building an Effective Data Warehouse Architecture
Thanks to everyone who attended my session “Building an Effective Data Warehouse Architecture” at the Houston Area SQL Server User Group Monthly Meeting....
2013-09-11
957 reads
My Hack…err…Rube Goldberg Machine
My deadline is fast approaching. It seems these days that editors have no patience. On top of that there is this ever-shrinking deadline problem and the constantly shrinking lead-time...
2013-09-10
18 reads
My Hack…err…Rube Goldberg Machine
My deadline is fast approaching. It seems these days that editors have no patience. On top of that there is...
2013-09-10
839 reads
T-SQL Tuesday #46–The Rube Goldberg Machine
It’s T-SQL Tuesday time again. This is the monthly blog party where we all write on a topic. This month...
2013-09-10
1,019 reads
PASS Summit 2013 Schedule
Each year, I like to compile my own shortcut, cheat sheet version of the PASS Summit schedule. I’m not talking...
2013-09-10
1,063 reads
PASS Data Arch VC presents Louis Davidson Relational Database “Good Enough”
Please join us Thursday Sept 12th at noon Central for the monthly Data Architecture Virtual Chapter presentation. We will have...
2013-09-10
457 reads
SQLBits XI videos online
All the videos for this popular conference are online (69 of them). Take a look at the recorded sessions at http://sqlbits.com/content/Event11. ...
2013-09-10
1,019 reads
New Windows Azure Virtual Labs
Getting started with new technologies can be a pain. That makes all the new labs that Microsoft just posted extremely...
2013-09-10
595 reads
Sometimes I don't understand Microsoft's vulnerability classifications
Here's a great example:
MS13-079 - Vulnerability in Active Directory Could Allow Denial of Service (2853587)
Basically, this patches a vulnerability where an...
2013-09-10
1,886 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