Monday Coffee – Lab Environments
Having a lab environment is an absolute must for any IT professional. You need somewhere that you can test out...
2017-06-05
282 reads
Blog Posts
Setting up the Power BI Report Server Preview
Last week on May 17th the Power BI team announced the release of the Power BI Report Server preview. Power...
2017-06-05 (first published: 2017-05-23)
3,108 reads
SQL Server – Service Terminated
I had a messy (another one) day, last thing I wanted was a “broken” SQL Server instance where I was...
2017-06-05
409 reads
SQL Server Application Roles
If you’re using Windows Authentication then you probably have a database user for each user of your application or at...
2017-06-05
198 reads
SQL Server Monitoring: Creating your own metrics
The one and only important factor in monitoring is data. How much of x and how little of y? If...
2017-06-05
579 reads
SQLSat Pcola 2017 Security Principals and Permissions
Great attendance and awesome questions from my afternoon session on "SQL Security Principals and Permissions". As promised, both the demo...
2017-06-05
276 reads
SQLSaturday Orlando 2017 Goes Live
Today we’re starting on our 11th SQLSaturday here in Orlando. Normally we rotate the leadership between oPASS and MagicPASS, but...
2017-06-05
507 reads
Top Function – Performance Gain
Recently, I presented at Singapore SQL Pass Chapter on the topic T-SQL Fun, and the most of the attendees were...
2017-06-05
482 reads
VSTS– Hosted Agent is the Default for Releases
In keeping with the idea I don’t want this to get out of date, this is VSTS as of Jun...
2017-06-05
612 reads
SQL Graph, part I
This blog is a kick-off the series that will be dedicated to the graph databases and engines, being more specifically...
2017-06-03
1,221 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers