Code I’d Hate To Live Without: T-SQL Tuesday #104
It’s TSQL Tuesday again! This time our respected host is Bert Wagner (b/t). Quick aside, if you haven’t seen his...
2018-07-19 (first published: 2018-07-10)
3,646 reads
SQLStudies
SQL Homework – July 2018 – Create a SQL Agent Job
For this month’s homework let’s try something a bit different. SQL Agent jobs are a very powerful tool frequently used...
2018-07-13 (first published: 2018-07-02)
2,012 reads
SQL Puzzle – FizzBuzz3d
I thought for the end of the month it would be fun to do another T-SQL Puzzle. In this case...
2018-07-04 (first published: 2018-06-27)
2,169 reads
Be our guest, be our guest, put our database to the test.
When I think of the public role I often think of the guest database principal (user) at the same time....
2018-06-25
281 reads
Strings vs Identifiers
A common mistake, and one I make frequently myself is to use a string in place of an identifier, or...
2018-07-02 (first published: 2018-06-20)
3,390 reads
Misleading errors: “Server is configured for Windows authentication only.” But it’s not!
In general, the errors SQL gives are highly useful. Of course every now and again you get one that’s just...
2018-06-18
797 reads
The identity column, the insert and the linked server.
tl;dr; When doing an insert across a linked server you have to include the list of fields to be inserted...
2018-06-14
519 reads
Moving to Azure: A change in processes – TSQL Tuesday 103
For this month’s t-sql Tuesday our host Bjoern Peters (b/t) wants us to describe our experiences with Azure SQL Database...
2018-06-22 (first published: 2018-06-12)
2,402 reads
What queries are getting blocked?
Monday Grant Fritchey (b/t) put up a great post EXTENDED EVENTS, THE SYSTEM_HEALTH SESSION, AND WAITS that talks about how...
2018-06-14 (first published: 2018-06-06)
2,677 reads
SQL Homework – June 2018 – Alter a database
Here we are again. The beginning of another month. At the beginning of each month I put out a SQL...
2018-06-04
242 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