Creating logins and users in Azure Database
Azure Database is the PaaS solution for SQL Server databases, on a previous post we have discussed how to create one.On this post, I want to show you how...
2019-04-11
17 reads
Blog Posts
Creating logins and users in Azure Database
Azure Database is the PaaS solution for SQL Server databases, on a previous post we have discussed how to create one.On this post, I want to show you how...
2019-04-11
40,791 reads
Find Occurrences of a String Anywhere on an Instance
Oh, the dreaded string search (on an entire instance). What to do?
2019-04-11
195 reads
Information Measurement with SQL Server Part 4.4: Sørensen Distance and Its Relatives
By Steve Bolton …………As I discussed in more depth in the last three articles (not counting last month’s digression into Fisher Information, which is out of numerical order), theoreticians...
2019-04-11 (first published: 2019-03-30)
537 reads
Power BI Monthly Digest – April 2019
In this month’s Power BI Digest with Manuel Quintana [Blog | Twitter] and I will again guide you through some of our favorite Power BI
2019-04-11
86 reads
SSMS GUI not working? Try to use T-SQL!
One of the good things, when we have new clients, is that sometimes they have needs that you never heard before. This does not necessarily mean that they are...
2019-04-11 (first published: 2019-03-29)
1,143 reads
Tuning Azure SQL Elastic Pools
The below image is a beautiful picture, now it could be worse. The red line and the green line could peak at the same time and for a very...
2019-04-11
157 reads
Database Recovery Monitoring with XE
Database recovery (crash recovery) is a nerve wrenching situation under the wrong conditions. It can be as bad as a root canal and just as necessary to endure that...
2019-04-10
10 reads
Notes from SQLSaturday Tampa 2019
Late notes! Great signs at the event, all hand written on flip chart paper. Cheap and effective, the “different” nature of the signs made them easy to spot Rooms...
2019-04-10
13 reads
Power BI Now Has Keyboard Accessible Visual Interactions
The March 2019 release of Power BI Desktop has brought us keyboard accessible visual interactions. One of Power BI’s natural...
2019-04-10 (first published: 2019-03-21)
1,875 reads
Blogs
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
AI: Blog a Day – Day 2: Generative AI, Multimodal Systems, and Agent AI
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers