Why are my permissions missing?
You’d be amazed (or maybe you wouldn’t) how often I hear this: “I used to be able to do xyz ... Continue reading
2021-06-22
2 reads
Kenneth Fisher
CROSS vs OUTER APPLY
I love CROSS APPLY. I also love OUTER APPLY. What’s the difference though? The same difference as with an INNER ... Continue reading
2021-06-21 (first published: 2021-06-10)
978 reads
My journey with hybrid technologies. Where it started, how it’s going, and where it ends. : T-SQL Tuesday #139
One of my favorite people is hosting TSQL Tuesday this month. Ben Weissman (blog|twitter). He wants us to talk about ... Continue reading
2021-06-18 (first published: 2021-06-08)
236 reads
#PowershellBasics: Finding a common AD group for a set of users.
A while back (almost 7 years ??) I wrote a post on finding the common AD groups of a set ... Continue reading
2021-06-17
68 reads
Long names vs short names (or aliases)
I remember when I was first learning to code there was always the argument of how long a name should ... Continue reading
2021-06-15
105 reads
SQL Homework – June 2021 – SQL Audits
Last month I had you work on Extended Events, so hopefully now you are a bit more comfortable with them. ... Continue reading
2021-06-14 (first published: 2021-06-01)
255 reads
The WITDC Mental Health and Wellness day and why July 2020 really sucked for me.
I recently gave a presentation at the WITDC Mental Health and Wellness day. The recordings are out and here’s the ... Continue reading
2021-06-11 (first published: 2021-05-27)
191 reads
#PowershellBasics: Writing to the screen
Writing to the screen is a really basic debugging technique. That said, since I’m really new with Powershell this is ... Continue reading
2021-06-04 (first published: 2021-05-20)
572 reads
Use BCP to create a CSV (comma delimited) file from a table.
This is a pretty handy little tool in your arsenal. I’ve talked about using bcp to transfer data from one ... Continue reading
2021-06-03
149 reads
Creating a configurable SSMS script
Several times over the last few weeks I’ve gotten a request to create a new work database. The individuals from ... Continue reading
2021-05-28 (first published: 2021-05-18)
674 reads
Blogs
Daily Coping 22 Jun 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Why are my permissions missing?
You’d be amazed (or maybe you wouldn’t) how often I hear this: “I used...
Suggested Topics in Power Virtual Agents
By Devin-Knight
Power Virtual Agents empowers subject matter experts to build intelligent conversational bots, using a...
Forums
Migrating Folder Structure in Report Manager from one SSRS server to another
We are in the process of converting 500+ reports from our old reporting system...
Setting up and using dbt (Data Build Tool) with SQL Server
dbt, or Data Build Tool, is a piece of software that allows analysts to...
SSRS 2016 data source - Azure SQL DB not working
Hello! I am trying to create data source to connect to Azure SQL DB...
Ask SSC