Redgate Reviews 2018, Predicts 2019
Our boss came to us and said, “We need one more webinar to round out the year.” Well, we’re just...
2018-12-17
175 reads
Blog Posts
Savings changes is not permitted. The changes you have made require the following tables to be dropped and re-created.
Microsoft does a lot of things to try to help us not shoot ourselves in the foot. This little error...
2018-12-17
1,014 reads
SQL Server services will not start automatically after server reboots
This blog post is about a situation where after windows patching the SQL Server service and SQL Server Agent services...
2018-12-17
309 reads
The Data Catalog from Redgate
One of the important tasks that is needed for any organization that wants to better protect their sensitive data is...
2018-12-17
357 reads
Why do we think water and databases are similar?
It’s 20 years since Google was launched, the Euro was agreed, and the Three Tenors sang at the World Cup opening ceremony. That was also the year (1998) when...
2018-12-17
17 reads
Why do we think water and databases are similar?
It’s 20 years since Google was launched, the Euro was agreed, and the Three Tenors sang at the World Cup...
2018-12-17
227 reads
Global AI Bootcamp – Developing AI, responsibly
Global AI Bootcamp, Brisbane 2018
Yesterday, I attended the Global AI Bootcamp Brisbane (at the Precinct, Valley) along with nearly 100 other...
2018-12-16
445 reads
Global AI Bootcamp – Developing AI, responsibly
Global AI Bootcamp, Brisbane 2018 Yesterday, I attended the Global AI Bootcamp Brisbane (at the Precinct, Valley) along with nearly 100 other technology enthusiasts. The event was well organized by...
2018-12-16
10 reads
Last week reading (2018-12-16)
Hello data geeks. Last week we had many news about Cosmos DB, and this time the top topics are Power...
2018-12-16
180 reads
Extract the File Name in SSIS Data Flows using the FileNameColumnName Property
When extracting data from a flat file, it is handy to have the name of the file from which the data was retrieved. Whether you capture this information for...
2018-12-15
27 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
SSRS Reminded Me of the Time Microsoft Retired TMG
Comments posted to this topic are about the item SSRS Reminded Me of the...
Getting results from a Procedure to join to a query
I have a need to execute a stored procedure and return the results to...
Upgrade 2016 Standard to 2022 Express
Title pretty much says it all - can this be done? I've tried several...
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers