Are your disks formatted with UseLargeFRS?
PureStorage has a pretty cool post that mentions the importance of formatting SQL Server disks with a 64KB clusters and...
2017-10-18
2,699 reads
Blog Posts
Connecting to a Remote Instance of SQL Server Using Python
SQL Server’s integration of Python has been heavily marketed towards the machine learning and BI guys, but does it offer...
2017-10-18
1,193 reads
Datalere Presents Data Science, Cloud, Business Intelligence and Data Warehousing at PASS Summit
Pacific North West, 4000 attendees, training, trends and worldwide industry experts. In a nut shell, the world’s largest conference for...
2017-10-18
160 reads
Does Your Code Have a Preamble?
Okay, here is a pet peeve of mine, I think every stored procedure, function, view etc. should all contain a...
2017-10-18
486 reads
Rebooting Ubuntu Linux from the Command Line–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-10-18
540 reads
SpeedPASS Download Naming Convention
This was the first time in a long time that I managed the check-in process of SQLSaturday Orlando and was...
2017-10-18 (first published: 2017-10-09)
1,519 reads
SQL Server 2017 Encrypted Backups And Compression
Let’s work through some code to do an encrypted backup. This feature is available to you if you are using...
2017-10-18 (first published: 2017-10-09)
3,106 reads
The perils of RAID
Recently, I was asked to assist an organization with getting their data back for a SQL Server that had experienced...
2017-10-18
632 reads
Updateable CTEs
CTEs are cool things. You can essentially create one or more in-line view(s) within your query. One thing that isn’t...
2017-10-18
1,970 reads
Automating Everything with PowerShell – Getting Started #tsql2sday
I try to automate everything I can with PowerShell. Whether we’re talking SQL Server, WSUS, Active Directory, or any other...
2017-10-17
907 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers