SQL Named Instance – Static Port Overrides with SQL Browser
I ran across an issue that I haven’t seen since SQL 2000 and had almost forgotten about. Let’s do a...
2014-03-03
1,273 reads
Blog Posts
SQL Server Quickie #11 – Non Clustered Indexes
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-03-03
435 reads
SSRS Top N and Bottom N reporting with Duplicates
Previously I wrote a blog on Top N and Bottom N reporting. There were a couple of gotcha I did...
2014-03-03
1,236 reads
Suggestion for SQL Prompt and SQL Test (Red-Gate)
Recently I moved my job on ALM topics, focusing on Source Control Management and Testing, in order to reach Continuous...
2014-03-03
531 reads
Upcoming Conferences: SQLSaturdays in Denmark and Portugal. – Presenting In-Memory OLTP Deep-Dive for Administrators
(de)
Im März und April finden 2 europäischen SQLSaturdays statt, die Potential zu einem Geheimtipp haben:
Am 29. März in Kopenhagen, Dänemark
...
2014-03-03
825 reads
Using SQLFiddle
SQL Fiddle is a free website that you can use to demonstrate and save a query example in any one...
2014-03-03
3,090 reads
Fun in DateTime Calculations
Recently I was working on a task that needs to handle various datetime calculations, and it is really fun.
Usually there...
2014-03-02
722 reads
Browser Based Web Notifications
3 of the 4 major browsers now support web notifications (Safari, Firefox, Chrome) and no where near enough sites are...
2014-03-01
50 reads
Cloning a SQL Server Database
The following script will backup and restore a database to the same server with a different name. Tested on SQL...
2014-03-01
51 reads
Friday Followup For February 28, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-02-28
1,132 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