Read Flat File Contents to Variable – Write Variable Value to Flat File
When working with SSIS, you’ll often find the need to read the contents of a flat file to a variable,...
2014-04-22 (first published: 2014-04-08)
7,581 reads
Blog Posts
SQL Server Internals Presentation Double Time!
I’ll be doing double time over the next two weeks with Two Presentations on SQL Server Internals. It is essentially...
2014-04-22
667 reads
SQL Server Training – Spring 2014
I have just returned from a trip to Washington DC where I was delivering course 2105 – SQL Server 2012 DBA...
2014-04-22
843 reads
The Powershell Challenge Update
I’ve fallen down on my challenge over the last month. It’s been a content time, with me working more towards...
2014-04-22
752 reads
Collation: Temporary objects and variables: Demonstration
I had a recent run in with collation problems and it got me started reading about them. As I read...
2014-04-21
473 reads
Notes From The April 2014 oPASS Meeting
Same room but different seating arrangement. Instead of separate table pushed some together, used the space better and more a...
2014-04-21
523 reads
The system_health Extended Event Session
When I first started poking around in SQL Server 2012, I noticed an extended event session called “system_health” was created...
2014-04-21 (first published: 2014-04-08)
4,067 reads
Creating a Dynamic, Parameterized Measure in DAX
As I continue to explore the many facets of DAX functions, I’m finding more creative ways to add business value...
2014-04-20
891 reads
Modern DataWarehouse: The Weakest Link
It has been quite some time, that the term Modern Data Warehouse has appeared on the horizon of so many...
2014-04-20
210 reads
New release 2.4.5222
Today we released new version of SQL Code Guard - 2.4.5222There are many fixes and improvements, some new rules were added.Full...
2014-04-20
347 reads
Blogs
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
Forums
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
The End of Summer
Comments posted to this topic are about the item The End of Summer
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers