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
Scaling Azure SQL Database
One of the advantages Azure SQL Database has over on-prem SQL Server is the ease in which it can scale. I’ll...
2016-02-03
800 reads
Blogger questions: What if someone else wrote about the same subject?
I have a moderately popular blog. In part because I syndicate but largely (in my opinion) because I write a...
2016-02-03
567 reads
The Future of SSMS
One of the smaller announcements amidst the gazillion new features of SQL Server 2016, is that SSMS is now a...
2016-02-03
630 reads
Limitation of In-Memory OLTP in SQL Server 2016 – TRUNCATE table not supported
Hi friends, another limitation that we will discussed is TRUNCATE table command is not supported with memory optimized tables. Let’s...
2016-02-03
1,393 reads
Should I use option(recompile)?
Should I use option(recompile)?
This will probably be a multiple stage discussion. The notes I’m providing today were sparked off of...
2016-02-02
6,949 reads
How to Install Microsoft R Server for Windows
Microsoft R Server, or Revolution R Enterprise (RRE) as it is formally known, for now, is basically a platform for...
2016-02-11 (first published: 2016-02-02)
3,033 reads
On the addition of useless where clauses
I remember a forum thread from a while back. The question was on how to get rid of the index...
2016-02-10 (first published: 2016-02-02)
2,416 reads
Speaking at OPASS on February 25, 2016
Last month I visited MagicPASS, this month I’ll be at oPASS and presenting again on my pattern for automating database...
2016-02-02
555 reads
Blogs
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...
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...
Forums
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
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...
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