Quick Tips–SQL Prompt Formatting
I love SQL Prompt, and think it’s a great productivity tool. Even before I worked at Red Gate, I love...
2014-05-20 (first published: 2014-05-14)
3,448 reads
Blog Posts
Running Out of Foreign Keys-Question of the Day
Running Out of Foreign Keys is live today. Nothing too interesting about this one, a straight forward question where you...
2014-05-20
343 reads
Tulsa User Group
I love user groups.
I have a special place in my heart for people who go out and give their time...
2014-05-20
632 reads
Varchar "miracle" and best practice
I've just spent fifteen minutes helping colleague to find "miracle in t-sql code".
- There should be rows, definitely! I can...
2014-05-20
672 reads
Add an Instance to SQL Server Azure Virtual Machine
How do you add an instance to your local SQL Server installation? You run the executable that you probably downloaded...
2014-05-19 (first published: 2014-05-13)
1,494 reads
Cannot start SSAS after install in tabular mode
After installing SSAS, using the tabular model, you receive the error “The service cannot be started: The following system error...
2014-05-19 (first published: 2014-05-13)
4,177 reads
FileTable– Using GetParent for Inserts
In a previous post, I looked at the ways in which I could insert files into a Filetable folder programmatically....
2014-05-19
1,358 reads
Finding Groups - Consecutive Months
A step by step explanation on one way to get a consecutive period of months, which could easily be adapted...
2014-05-19
668 reads
Know Backups and Know Restores – SQL Server Restores
A couple of years ago I put together a training session to demonstrate various types of backups and restores. The driving...
2014-05-19
1,292 reads
Last Weeks Top “Reading” Links #84
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-05-19
607 reads
Blogs
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
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...
Forums
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
The End of Summer
Comments posted to this topic are about the item The End of Summer
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers