How to Load Data from Excel in SSIS – 32-bit vs. 64-bit
Let’s say you are developing an SSIS package on your dev box to load data from an Excel file to...
2014-02-25
1,188 reads
Blog Posts
PolyBase explained
PolyBase is a new technology that integrates Microsoft’s MPP product, SQL Server Parallel Data Warehouse (PDW), with Hadoop. It is designed to...
2014-02-25 (first published: 2014-02-18)
18,179 reads
Spezialrabattaktionen: 22% zum Jubiläumsjahr der PASS Deutschland e.V für Sicherheits- XEvent Tracing, sowie SQL Server 2014 Seminare + 10% Microsoft TechNet Aktion für alle
Damit auch alle, die vor 2 Wochen nicht auf der SQL Konferenz in Darmstadt (www.sqlkonferenz.de) waren, oder nicht regelmäßig bei...
2014-02-25
745 reads
The CASE Statement and Performance
In case you don’t know, this query:
UPDATE dbo.Test1
SET C2 = 2
WHERE C1 LIKE '%33%';Will run quite a bit slower than this...
2014-02-25 (first published: 2014-02-18)
6,542 reads
Tonight: NYC Metro User Group Presents Kimberly L. Tripp & Jonathan Kehayias
Tonight: The NYC Metro User Group Presents Kimberly L. Tripp (blog) and Jonathan Kehayias (blog)!
Let's welcome them to NYC! Now at...
2014-02-25
1,214 reads
What is HDInsight?
There are two flavors of HDInsight: Windows Azure HDInsight Service and Microsoft HDInsight Server for Windows (recently quietly killed but...
2014-02-25
2,089 reads
31 Days of SSIS for SQL Server 2014 Update Question
A few years back, I put together a blog series on SQL Server Integration Services (SSIS) titled 31 Days of SSIS....
2014-02-24
1,299 reads
Accenture and DataStax Establish Big Data Alliance #bigdata
Accenture and DataStax have signed an alliance agreement, formalizing their longstanding collaboration in helping clients manage and drive insights from...
2014-02-24
582 reads
Expiration dates: SQL Server 2008 and 2008 R2
SQL Server is a software product, right? And software has a history of having bugs, getting updates, and having support...
2014-02-24
574 reads
Free Presentation Software
Here’s a list of free presentation software I ran across, maybe worth a few minutes to get out of the...
2014-02-24
733 reads
Blogs
The end of an era – why I chose not to renew my MVP
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
PowerShell Strikes Back: A New Script
By gbargsley
This is it. The final chapter of PowerShell Strikes Back. Over the past four...
Claude Desktop
By Arun Sirpal
Claude is more than a chat window. The desktop experience includes structured workspaces, generated...
Forums
Unraveling the Mysteries of the Ephemeral Model: The Fabric Modern Data Platform
Comments posted to this topic are about the item Unraveling the Mysteries of the...
QUOTENAME Behavior
Comments posted to this topic are about the item QUOTENAME Behavior
Running script without having permission to Function
Good Morning. I have a T-SQL Script which has been developed to execute a...
Question of the Day
QUOTENAME Behavior
I use QUOTENAME() like this in code?
DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '>')What is returned? See possible answers