Hmmm… What’s This?
OK So, I am doing some digging and peaking around again in SQL Server and came across a database option...
2017-09-27 (first published: 2017-09-20)
2,054 reads
TSQL2sDay – Get-PostRoundup
First an apology, this round up is late!
The reason for that is an error in the PowerShell testing module Pester...
2017-09-27 (first published: 2017-09-20)
1,069 reads
Dieser Blog ist umgezogen // This Blog has moved: http://andreas-wolter.com/blog/
http://andreas-wolter.com/blog/
Liebe Leser dieser Blog ist hiermit nur noch „Archiv“ und wird nicht mehr weiter gepflegt. Seit August 2017 finden sich neue Artikel ausschließlich unter der neuen URL:http://andreas-wolter.com/blog/
Dear Readers this...
2017-09-20
19 reads
Dieser Blog ist umgezogen // This Blog has moved: http://andreas-wolter.com/blog/
http://andreas-wolter.com/blog/
Liebe Leser
dieser Blog ist hiermit nur noch „Archiv“ und wird nicht mehr weiter gepflegt.
Seit August 2017 finden sich...
2017-09-20
333 reads
UNDERCOVER TOOLBOX: sp_Snapshot – The Easy Way To Create Database Snapshots for One or Many Database
sp_Snapshot is a procedure that we’ve written to quickly and easily create a database snapshot of one or multiple databases.
Prerequisites
sp_Snapshot...
2017-09-20
156 reads
The Tabular Model Documenter is now a Power BI Template
A while back I created the Tabular Model Documenter Power BI model that can connect to your SSAS Tabular or...
2017-09-26 (first published: 2017-09-19)
2,392 reads
How to change Integration Services Catalog (SSISDB) database Master Key encryption password?
To change the Integration Services Catalog (SSISDB) database Master Key encryption password, run the following Transact-SQL statement: In the above Transact-SQL fragment, we first open the Integration Services Catalog...
2017-09-19
20 reads
How to change Integration Services Catalog (SSISDB) database Master Key encryption password?
To change the Integration Services Catalog (SSISDB) database Master Key encryption password, run the following Transact-SQL statement:
USE [SSISDB];
GO
OPEN MASTER KEY...
2017-09-19
2,076 reads
Join me at VS Live – Anaheim
We’re just a month away from Visual Studio Live in Anaheim where I’ll be speaking along with many others. Join...
2017-09-19
465 reads
Four PASS Questions–My Take #PASSElections
As part of the campaign material for this years election for Board of Directors; the candidates were asked to answer...
2017-09-19
414 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
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
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