Granting or denying permissions to all of the tables within a database
When granting or denying permissions to the tables within a database you have two options. You can either add the...
2014-05-20 (first published: 2014-05-15)
4,125 reads
Blog Posts
Presenting at ONETUG on July 10, 2014
I’ll be presenting SQL Performance for Developers to the members of ONETUG on July 10, 2014. I’m going to hit...
2014-05-20
412 reads
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,443 reads
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
341 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
630 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
663 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,477 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,139 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,352 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
652 reads
Blogs
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers