PowerShell Script to configure SQL Server static Port
Read the article to use a PowerShell Script for configuring SQL Server static Port
2022-01-10
40 reads
Data and DevOps Predictions for 2022
All the Advocates at Redgate (Kathi, Grant, myself) got asked about some of the future predictions we might have, based on some of the data from The 2021 State...
2022-01-10
58 reads
Why Is “WHERE 1=0” Slow?
I saw a question the other day, questioning why they’re creation of temporary tables was so slow. What they were doing was (a much more complicated version of) this:...
2022-01-24 (first published: 2022-01-10)
916 reads
Architecture – The Perfect Enemy
When I was younger, I always wanted the perfect solution to an IT problem. I remember getting into argument after argument trying to insist upon the perfect configuration, setup,...
2022-01-21 (first published: 2022-01-10)
397 reads
Daily Coping 10 Jan 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-01-10
45 reads
SQL Server STUFF
The STUFF function in SQL Server is one of those little gems that is very under-used but when needed can be a real handy utility – at least that’s...
2022-01-10
47 reads
Connecting to an Azure SQL Database
Are you starting to experiment with Azure SQL Databases? Is your company interested in moving to the Cloud and asking you to investigate different options? This blog will show...
2022-01-08
252 reads
Bulk Insert – Insights That Will Make You Drool
Bulk insert can be an extremely helpful tool to help ingest data into SQL Server efficiently. Sometimes, it is necessary to capture metrics in regards to the bulk insert...
2022-01-24 (first published: 2022-01-07)
840 reads
Daily Coping 7 Jan 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-01-07
24 reads
Running Powershell code in Vim
I’ve been mucking about with Vim a bit recently and recently found myself (for reasons unknown tbh) writing powershell scripts in it. Once I’d written a script, I would...
2022-01-26 (first published: 2022-01-07)
376 reads
Blogs
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
How to Measure AI Value: A 6-Branch AI Maturity Model for Use Cases and Agents
Your AI is busy. But do you know what it's worth? Most companies can...
Forums
Alamat Telp BCA KCP Jamblang +62 838-4945-0961
Wa:083849450961 Jl. Jamblang Raya No.51, RT.2/RW.1, Duri Sel., Kec. Tambora, Kota Jakarta Barat, Daerah...
Telp BCA KCP Mandala Raya +62 838-4945-0961
Wa:083849450961 Jl. Mandala Raya No.14, RT.13/RW.5, Tomang, Kec. Grogol petamburan, Kota Jakarta Barat, Daerah...
SQL Server 2025 Server-level Roles
Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers