T-SQL Tuesday #75 Invitation: Jump into Power BI!
Hello everyone and welcome to this month’s T-SQL Tuesday. This month’s topic is all about Power BI! If you’re reading this and thinking “crap, I’m not a BI person!”,...
2016-02-08
17 reads
T-SQL Tuesday #75 Invitation: Jump into Power BI!
Hello everyone and welcome to this month’s T-SQL Tuesday. This month’s topic is all about Power BI! If you’re reading...
2016-02-08
568 reads
SQL Create Table
SQL CREATE TABLEThe CREATE TABLE statement is used to create a table in a database to stored data.Tables are organized...
2016-02-08
197 reads
SQL Basics for Beginner
SQL BasicsAn instruction to a database to combine data from more than one table.A SQL join combines records from two or more...
2016-02-08
939 reads
Database Log VLFs
Transaction logs are split into VLFs which affects performance. How large are yours and what does that mean for you?
2016-02-08
87 reads
Database Log VLFs
Virtual Log Files (VLFs) split a physical database log file into smaller segments, which are required for how log files...
2016-02-08
800 reads
.Net CLI Cross Platform Awesomeness
.Net CLI is the new tooling that sits in front of .Net Core, allowing you to create and run projects...
2016-02-07
47 reads
Friend of Redgate 2016
I’m excited to announce that I have been named a Friend of Redgate for 2016. The program targets influential people in their respective technical communities such as SQL, .NET and ALM and...
2016-02-07
19 reads
Friend of Redgate 2016
I’m excited to announce that I have been named a Friend of Redgate for 2016. The program targets influential people in their respective...
2016-02-07
583 reads
SQL Server Database File Size and Free Space Revisited
I recently had a comment posted to one of my first articles I wrote way back in 2012 concerning adding a column that detailed the used space as a...
2016-02-06
16 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