Automate Migrations–T-SQL Tuesday #94
It’s T-SQL Tuesday time again, and I’m slightly pressed for time, which is sad. This is a great topic.
Rob Sewell...
2017-09-12
416 reads
';SELECT *: How Unicode Homoglyphs Can Thwart Your Database Security
For the past couple weeks I've been writing about how to protect your database from a SQL injection attack. Today, we will keep the trend going by looking at how...
2017-09-12
65 reads
SQLOrlando
We’ve haven’t had a good solution for managing money for SQLSaturday and our groups here in Orlando. In the early...
2017-09-12
431 reads
Someone is not following the best practices – dbatools and Pester don’t lie!
This month’s T-SQL Tuesday is brought to us by my good friend Rob Sewell (b | t) and we will "Let’s...
2017-09-12
723 reads
#TSQL2sDay – Starting Out with PowerShell
This months TSQL2sday is hosted by me!
Surprise! – I chose PowerShell
I am really looking forward to seeing what other people post....
2017-09-12
597 reads
Warning Handling in dbatools Automation Tasks
So I’ve been using dbatools for automated restore tasks and came across a SQL Server Agent job that I wrote that was reporting success but the job was actually...
2017-09-12
6 reads
Warning Handling in dbatools Automation Tasks
So I’ve been using dbatools for automated restore tasks and came across a SQL Server Agent job that I wrote...
2017-09-12
385 reads
T-SQL Tuesday #94 - Automating Configuration Comparison
This month’s T-SQL Tuesday is hosted by Rob Sewell and he’s posed the following question:
What are you going to automate today with PowerShell?
I’m cheating a little bit in that...
2017-09-12
18 reads
#TSQL2sDay Long Story Short: Avoid -Scope User
For T-SQL Tuesday #94 the topic is databases and PowerShell. Rob Sewell asks us: What are you going to automate today? I’m going to automate some thing in SSRS...
2017-09-11
19 reads
#TSQL2sDay Long Story Short: Avoid -Scope User
For T-SQL Tuesday #94 the topic is databases and PowerShell. Rob Sewell asks us: What are you going to automate today? I’m going to automate some thing in SSRS...
2017-09-11
9 reads
Blogs
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Forums
Understanding Temp Tables and Table Variables in SQL Server
Comments posted to this topic are about the item Understanding Temp Tables and Table...
The Data API Builder MCP Server Tools
Comments posted to this topic are about the item The Data API Builder MCP...
Collecting Data Is Hard
Comments posted to this topic are about the item Collecting Data Is Hard
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers