Building Flat File Connectors Dynamically For SSIS
Building Connectors Is Crap in SSIS – Updated
What else can I say. I finally broke when I had to build a...
2013-07-10
1,954 reads
Blog Posts
energy
Back when I was trying to start a business and unknowingly heading towards a economic cliff, I read all sorts...
2013-07-10
597 reads
Hung SQL Server Restores from Tivoli Storage Manager/Tivoli Data Protection
I ran into this with a client last night when trying to restore their SQL Server data warehouse database from...
2013-07-10
2,510 reads
Report from a Cube in Reporting Services
Data warehousing has become a staple of businesses to help make business decisions. From these data warehouses you can develop...
2013-07-10 (first published: 2013-07-08)
2,694 reads
Security Questions: Logins Not In Use
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-07-10
607 reads
Security Questions: Logins, Credentials, and Proxies
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-07-10
1,680 reads
SQL Server: All About SQL Server Statistics : Consolidated post
Statistics is the one of the important factor which helps the optimizer to choose the right execution plan.At the same...
2013-07-10
979 reads
Find out orphan database file on disk
Sometimes you detach databases, or you delete a database which is in restoring status, the data and log file will...
2013-07-09
2,369 reads
PCI Compliance Presentation on July 17, 2013
Next week I’ll be doing a new presentation about PCI compliance – aka dealing with credit cards – online (follow this link...
2013-07-09
536 reads
Power BI for Office 365
Announced at Microsoft’s Worldwide Partner Conference 2013 is Power BI for Office 365:
Power BI for Office 365 is a cloud-based business intelligence...
2013-07-09
1,523 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