SQL Server database basics
So today I'll talk about some of the basic items for SQL server that helps to understand the reason of some performance recommendations. This first post will list and...
2017-09-16
14 reads
Blog Posts
Error Processing Tabular – Method Not Found
Very quick blog post today. While setting-up a development server at a client who is still using SQL Server 2012,...
2017-09-15
383 reads
Friday Reading 2017-09-15
Excited for next week as I’m heading down to Cork to speak at the User Group there. Over 3 years...
2017-09-15
370 reads
I want a new gadget with less features
Years ago I bought a Pebble smartwatch. I didn’t back the Kickstarter, but a few friends did and I liked...
2017-09-15
890 reads
Offtopic: Lifehack: Old tech has many purposes
For those that don’t know, I live in Texas. Been here all my life. There are two main things north...
2017-09-15 (first published: 2017-09-11)
1,623 reads
PASS Summit 2017 Precon – Virtual SQL Servers: Right to Ludicrous Speed
PASS has continues to ramp up the plans for the PASS Summit in Seattle this October, and my precon session, “Virtual...
2017-09-15
165 reads
PASS Summit 2017 Precon – Virtual SQL Servers: Right to Ludicrous Speed
PASS has continues to ramp up the plans for the PASS Summit in Seattle this October, and my precon session, “Virtual...
2017-09-15
368 reads
The Code Coverage Report
I had someone that told me recently that they needed to find a way to get code coverage in T-SQL....
2017-09-15
867 reads
What is networking, really?
I am still trying to get up to speed on blogging after a gap. Today I managed to push myself...
2017-09-15 (first published: 2017-09-10)
1,584 reads
[PowerShell] From 20 minutes to 20 seconds - Change domain user password on multiple domains without login into each one
I’m working on a environment where I have to deal with multiple domains. The user’s password needs to be updated each 40/45 days (it depends on the domain).
Because I...
2017-09-14
10 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