New SSDT Projects default to the latest version of SQL Server
When you create a new SSDT project it is created (at the moment) as a SQL Server 2014 project which...
2015-10-14
379 reads
Blog Posts
New SSDT Projects default to the latest version of SQL Server
When you create a new SSDT project it is created (at the moment) as a SQL Server 2014 project which is annoying when you are on something else.
However, if...
2015-10-14
1 reads
Speaking at SQL Saturday #452 - Charlotte, NC - October 17
In case you missed it last week, there will be another SQL Saturday this weekend in Charlotte, NC. If you...
2015-10-14
508 reads
Speaking at SQLSaturday #459, Madrid 2015
Glad to share that I have been picked up to speak at Spanish SQLSaturday for the second time in a...
2015-10-14
398 reads
SQL Server issue: switching partitions using the parameter with enabled replication
It’s quite an unpleasant thing that we had to face once. There was a working script, which had been functioning...
2015-10-14
1,635 reads
SQL Server issue: switching partitions using the parameter with enabled replication
It’s quite an unpleasant thing that we had to face once. There was a working script, which had been functioning for a long time and did not cause any...
2015-10-14
58 reads
SQL Server issue: switching partitions using the parameter with enabled replication
It’s quite an unpleasant thing that we had to face once. There was a working script, which had been functioning for a long time and did not cause any...
2015-10-14
14 reads
SSMS in High-DPI Displays: How to Stop the Madness
I spent the last few weeks travelling a lot compared to my usual routine and I got quickly fed up...
2015-10-14
41,216 reads
Auditing Needs Reporting
Welcome to the second Tuesday of the month. And in the database world of SQL Server and the SQL Server...
2015-10-13
689 reads
Auditing Needs Reporting
No matter the mechanism used to capture the data to fulfill the "investigation" phase of the audit, if the data is not analyzed and reports generated, then the audit...
2015-10-13
4 reads
Blogs
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers