Quick tip: format source code in html
I run a technical blog, so it is necessary to put code in almost every post. Most of the GUIs...
2018-04-25
101 reads
Dates and Times in SQL Server: T-SQL functions to get the current date and time
We have come on quite a journey so far. SQL Server and Azure SQL Database provide date and time data...
2018-04-25
393 reads
Thoughts and Lessons Learned From A Power BI Embedded POC
I worked on a Power BI embedded POC where a report with an in-memory Power BI model as the dataset...
2018-05-02 (first published: 2018-04-25)
3,208 reads
Benefits for Veterans
Wanted to share a few things I came across recently with regards to benefits for veterans:
You can get a printed...
2018-04-25
350 reads
Live, Learn, and Grow
Ever look back at old work and wonder what was I thinking when I did that? Or even better you...
2018-04-25
337 reads
What is a DBA?
If you’ve worked in the data industry for more than few minutes then you’ve probably heard the phrase The DBA...
2018-04-25
338 reads
State of the Cloud Database: April 2018
It’s an exciting time to be a database professional. The technology is advancing quickly, large datasets are easier to handle than ever before, and the cloud is opening up...
2018-04-25
13 reads
State of the Cloud Database: April 2018
It’s an exciting time to be a database professional. The technology is advancing quickly, large datasets are easier to handle...
2018-05-01 (first published: 2018-04-25)
2,810 reads
Getting the Azure DTU Calculator to work on a 2008R2 OS w/ a 2008R2 SQL Server Instance
Hello everyone! I recently had to do an analysis of a client’s database workload using the Azure DTU Calculator(DTU Calculator)...
2018-04-24
1,209 reads
Database Files Down The Wrong Path
I manage a few servers used to host SQL Instances for development and test purposes. Each of those instances hosts...
2018-05-02 (first published: 2018-04-24)
2,961 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