Copying SSIS packages With DTUTIL
A frequent need when performing a server migration is to copy the SSIS packages from one server to a new...
2016-02-15 (first published: 2016-02-05)
6,487 reads
Using Custom File Delimiters in SSIS
File-based ETL is usually dull. Most systems generate (or expect to consume) files that are delimited, with a common field...
2016-02-16 (first published: 2016-02-05)
2,700 reads
Its been a busy start to the year
Its been a busy start to the year at gethynellis.com. I have been involved in a Big Data training courses...
2016-02-05
493 reads
PASS Summit 2016 – call for Speakers…
PASS Summit 2016 is the biggest, largest, highest rated summit in the World for the Microsoft SQL Server & BI professionals,...
2016-02-05
798 reads
Minnesota BI User Group – Powering Up HDInsight with Power BI (December 2015)
On Wednesday, December 16, I presented on this topic at the Minnesota BI User Group. This session is based on...
2016-02-04
561 reads
Positivity
I’m sitting in the classroom of SQL Cruise listening to Tim Ford (b|t) explain mechanisms for monitoring indexes. It’s a...
2016-02-04
555 reads
Columnstore Indexes – part 76 (“Compression Delay”)
Continuation from the previous 75 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
While playing with SQL Server 2016 CTP...
2016-02-04
794 reads
Recertifying SQL Server 2012 MCSE with Microsoft Virtual Academy
Do people still get certified? I don’t hear much about it in the SQL community these days so I asked...
2016-02-04
498 reads
Loading a Text File with a Line Feed
Loading text files is a skill that probably every DBA needs. I know that the import wizard is available, but...
2016-02-04
1,226 reads
SQL Server Reporting Services 2016 – Part 1
This first post of 3 takes a quick peek at SSRS 2016 using the Community Technical Preview (CTP) 3.2. I...
2016-02-03
1,342 reads
Blogs
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Forums
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Tracking All the Queries
Comments posted to this topic are about the item Tracking All the Queries
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers