What’s the Mashup Engine?
I was testing something the other day and ran sp_who2 on a test instance. I saw this in the program listing: I had never seen the Mashup Engine listed...
2019-04-24
24,860 reads
The Voice of the DBA
SQLServerCentral Design–QotD
This is part of a series of posts that look at the changes to the SQLServerCentral design, bringing us to v3 of the site. You can see the other...
2019-04-19
67 reads
Generating an SSH key on Windows
I needed an SSH key. First I needed to the WSL subsystem, and once I had that working, I could do the work I needed to do: get an...
2019-04-15
784 reads
SQLServerCentral Design Decisions–Forum Threads
It’s been a long couple of weeks. Almost two weeks ago we cut over from our older, v2 version of the site to the new (and current) v3. Lots...
2019-04-12
35 reads
T-SQL Tuesday #113–Personal Databases
This month we have a really interesting question for the T-SQL Tuesday invitation. Todd Kleinhans is the host and asks about personal databases. Do we use them for anything?...
2019-04-09
38 reads
Adding bash to Windows 10
Awhile back I added the Windows Subsystem for Linux to my machine, rebooted, and promptly forgot about it. After all, I’m doing more PoSh these days and bash isn’t...
2019-04-05
43 reads
SQL in the City Streamed is Today
You can still register, but join me later today for SQL in the City Streamed, along with Grant, Kathi, and Kendra. We’re all in the Redgate Software office today...
2019-04-03
17 reads
Customizing Statistics Histogram in SQL Server 2019
The use of statistics in SQL Server is tightly embedded in the query optimizer and query processor. The creation and maintenance of statistics is usually handled by the SQL...
2019-04-01
211 reads
SQL in the City Summits coming this spring
The SQL in the City Summits are back for 2019, and we’ve got more scheduled than every before. You can see the complete list on our event page, and...
2019-03-27
118 reads
SQL Source Control and Bitbucket–Getting Started
This is in response to someone asking about getting started with their database in SQL Source Control and then hosting at BitBucket. I’m going to assume people can set...
2019-03-25
410 reads
Blogs
Down the Rabbit Hole: Dealing with Ad-Hoc Data Requests
By Rayis Imayev
"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help...
Adding a Local Model to Ollama through the GUI
By Steve Jones
I saw some good reviews of the small gemma3 model in a few places...
Connect resiliently to SQL Server
Why you should connect resiliently to SQL Server Transient failures happen — in the cloud...
Forums
Some query values change when query is run but not others. Why?
Hi everyone I have a 1000 line SQL query that is too long to...
using different credentials when debugging ssis
hi, now and then i want one connection in my ssis pkgs to use...
AlwaysON health check alerts
Comments posted to this topic are about the item AlwaysON health check alerts