Loop Through Excel Files in SSIS
You can loop through excel files using SSIS. This will use the For Each Loop container and a data flow...
2013-09-16
1,957 reads
Blog Posts
New Whitepaper: 5 Most Common Critical SQL Integrity Issues
Have you been putting off running integrity checks on your databases? Are you unsire where to start or what to...
2013-09-16
1,206 reads
Notes from SQLSaturday #232 in Orlando
Our seventh annual SQLSaturday here in Orlando went well. To the casual observer it might appear to happen without effort,...
2013-09-16
664 reads
PowerShell – List Local or Remote Programs with an Exclusion List of Programs
This post is to list all the software installed on your local or remote machines. The exclusion list is an...
2013-09-16
1,274 reads
SQL Saturday #191 Kansas City was Great
This past weekend I presented a preview of my SQL PASS Summit spotlight session entitled “Squeezing Top Performance From Your...
2013-09-16
582 reads
SQL Server – How to Create Registered Servers to Easily Manage and Query Multiple Instances at a Time
Registered servers is a great way to manage, categorize and access the SQL servers through SSMS and also one of...
2013-09-16
501 reads
SQL SERVER 2012 - How to get a value from previous result row effectively
Reblogged from SQL Server Portal: I came across this query many times and most often we need the previous row...
2013-09-16
695 reads
SQLSaturday #250 Pittsburgh
SQLSaturday #250 Pittsburgh is in the books, and I'd like to sincerely thank the organizers, sponsors, volunteers, and speakers for...
2013-09-16
475 reads
Thoughts About MS Advanced Certification
Now MS has decided to cancel all its advanced certifications. I am here to share some of my thoughts on...
2013-09-16
388 reads
Thoughts About MS Advanced Certification
Now MS has decided to cancel all its advanced certifications. I am here to share some of my thoughts on...
2013-09-16
737 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers