Block Select/Replace (Day 11)
While Regular Expressions lets us work with text not cleanly formatted, if you are trying to work with text that...
2018-01-11
240 reads
Wayne Sheffield
- Website: http://www.waynesheffield.com
Regular Expressions (Day 10)
Have you ever downloaded a script from an internet site, only to find that there are extra blank lines between...
2018-01-10
454 reads
Multi-Server Queries (Day 9)
Have you ever had to run a query on multiple servers? You could connect to each server one by one...
2018-01-09
447 reads
SQLCMD Mode (Day 8)
Have you ever had a script where you needed to run parts of it on different instances of SQL Server...
2018-01-08
442 reads
SSMS Solutions (Day 1)
Since SSMS is built upon Visual Studio, many of the features available to Visual Studio are also available to SSMS....
2018-01-08 (first published: 2018-01-01)
3,244 reads
Vertical Scroll Bar Map Mode (Day 6)
Have you ever had a long script that you are trying to scroll through? Do you wish that you could...
2018-01-06
569 reads
Working with Query Files (Day 5)
So you’re working with a query that you have loaded from a saved file. And now you want to open...
2018-01-05
374 reads
Pinned Tabs (Day 4)
Have you ever been working in SSMS where you need to frequently access one particular script, but you are spending...
2018-01-04
422 reads
Tab Groups (Day 3)
Have you ever wanted to have two different queries open up at the same time where you could see them,...
2018-01-03
332 reads
Automatic Plan Correction
SQL Server 2017 lets you solve parameter sniffing problems - Automatically!
2018-01-02 (first published: 2017-11-20)
2,704 reads
Blogs
TRY_PARSE Limitations: #SQLNewBlogger
By Steve Jones
I got a notification from a question I’d posted at SQL Server Central: Getting...
SQL Server sa Account Security: Rename, Disable & Best Practices
By SQLPals
SQL Server sa Account Security: Rename, Disable & Best Practices In...
Stanford Emerging Technology Review 2026 Report is out
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
Forums
Kontak BCA KCU SEMARANG Telp:(08218154392)
Alamat Kontak WA CS 08218154392 Jl. Pemuda No.90-92, Kembangsari, Kec. Semarang Tengah, Kota Semarang,...
Alamat Kantor BCA KCU Green Garden Tlp:08217555651
Hub Via Wa:628217555651 Alamat: Blok A.7 No, Komplek, Jl. Perumahan Green Garden 31-35, RT.1/RW.3,...
Alamat Kantor BCA KCU Sunter Telp:08217555651
Hub Via Wa:628217555651 Alamat: Jl. Danau Sunter Utara Jalan Kavling No.3 Blok A, RT.2/RW.18,...
Question of the Day
A Limited Startup
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers