SQL and the other technologies
I was curious about how the SQL language stands with the other technologies. Next table shows it. The data is taken from StackOverflow. Charted data looks like in...
2017-02-01
12 reads
SQL and the other technologies
I was curious about how the SQL language stands with the other technologies. Next table shows it. The data is taken from StackOverflow. Charted data looks like in...
2017-02-01
15 reads
SQL and the other technologies
I was curious about how the SQL language stands with the other technologies. Next table shows it. The data is...
2017-01-31
542 reads
JSON Support Is The Best New Developer Feature in SQL 2016 — Part 2: Creating JSON
This is the second article in my series about learning how to use SQL Server 2016's new JSON functions. If you haven't already, you can read Part 1?—?Parsing JSON.
Part...
2017-01-31
24 reads
Disabling #sqlprompt Formatting
I love SQL Prompt, especially the new formatting engine. However, it’s not perfect, and there are times I don’t want...
2017-01-31
942 reads
Pesky Percent File Growth
As DBAs we all know setting your file growth to grow by percent is not optimal. It can cause all...
2017-01-31
744 reads
Hiring Productive Employees – #TAPtips
Starting a business is easy. Have an idea, some skills, a customer or two, and you are in business. However,...
2017-01-31
640 reads
My First SQL Saturday – As A Speaker!
I am so honored and excited to have been selected to speak at SQL Saturday Richmond on March 18, 2017.
I...
2017-01-31
609 reads
A Letter To A Younger Yates
Hello much younger Yates. Hope you’ve been doing well. Why don’t you pull up a chair and stay for a...
2017-01-31
691 reads
Join webinar on SQL Server 2016 Always on
Click [HERE} to Join webinar.
SQL Server 2016 - AlwaysOn
An availability group supports a failover environment for a discrete set of user databases, known...
2017-01-31
548 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