How to sync user logins across SQL Server instances – dbatools is brilliant
This blog post is about how brilliant dbatools are. In this case – for syncing user logins between SQL Server instances.
Background:
Whenever...
2018-04-13
1,058 reads
The Hybrid DBA's Blog
How to change the TFS Agent _work folder
This blog post is about how to change the default work folder _work that TFS agents use when building a...
2018-04-10
595 reads
Use Boot Diagnostics to see what your Azure VM is doing at boot time
This blog post is about how to diagnose what your Azure VM is doing while it is booting.
I have a...
2018-04-06 (first published: 2018-04-04)
1,642 reads
Authentication issues with GitHub: An error occurred while sending the request —> System.Net.WebException: The request was aborted: Could not create SSL/TLS secure channel.
This blog post is about an error that you may receive if you’re using git commands in PowerShell and authenticating...
2018-03-31
704 reads
Redgate SQL Test utility isn’t showing up in SSMS
I had recently installed the SQL Toolbelt from Redgate at a client site on a laptop they’d supplied me.
(Fantastic product...
2018-03-21
375 reads
Automation and cleaner code/data are the key to future success
This blog post is a copy of a post I wrote for SQL Masters Consulting as part of T-SQL Tuesday....
2018-03-15
256 reads
Doing DevOPs for your Database? You need to start here…
I’ve been doing that thing called DevOPs for about 17 years – you know – before it had a name…
In fact it...
2018-02-28
1,260 reads
The Data Platform has expanded – so too should our approach in using it….
In recent years we as data professionals have moved from dealing with SQL Server databases with SQL Server Reporting Server...
2018-02-26
495 reads
If your Surface Book loses it’s keyboard and trackpad – try removing KB4074588 update
My Surface Book (gen 1) recently did updates and then a day or so later the keyboard and trackpad mysteriously...
2018-02-24
453 reads
Speaking at PASS Summit and why you need to think about submitting….
This post is about the honor and experience of speaking at PASS Summit not once (2016) but twice (2017).
I recently...
2018-01-29
387 reads
Blogs
Understanding Fabric Ontology
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
QUOTENAME Basics: #SQLNewBlogger
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
When growing companies outgrow Excel
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
Forums
BCA KCP Manyar Telpon/WA:083179431313
WhatsApp:083179431313 Jl. Barata Jaya No. 76-76A, Baratajaya, Kec. Gubeng, Surabaya, Jawa Timur 60245
BCA KCP M. Duryat Telpon/WA:083179431313
WhatsApp:083179431313 Jl. Kombes Pol. Moh. Duryat No.5-6 Blok A, Tegalsari, Kec. Tegalsari, Surabaya, Jawa...
BCA KCU HR MUHAMMAD Telpon/WA:083179431313
WhatsApp:083179431313 Jl. Mayjen HR. Muhammad No.17, Putat Gede, Kec. Sukomanunggal, Surabaya, Jawa Timur 60189
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers