(Kenneth Fisher) tl;dr; The uniquifier is used to make a non-unique key in a clustered index unique.
Tag: sql server
(Dennes Torres) How can you ensure that passwords conform to a policy, even if they are used for connecting applications to databases? Absolving them from the policy is a security risk and you don’t want to trouble the users with password changes.
(Michael Otey) SQL Server 2017 on Linux gives IT shops greater flexibility, but there are some limitations and changes to the way high availability and failover are performed on Linux vs. Windows.
(Pinal Dave) DBCC INPUTBUFFER has been one of the most popular commands to display the last statement sent from a client to an instance of Microsoft SQL Server. We all have been using it for quite a while.
(Jorg Klein) Finally, at Ignite Azure Data Factory Version 2 is announced! A giant step forward if you ask me. In this blog post I will give an overview of the highlights of this exciting new preview version of Azure’s data movement and transformation PaaS service. ADF V2 pricing can be found here.
(Krishnakumar Rukmangathan) Analysis Services model can be deployed in Azure in different ways like from SSDT or by running the JSON create script from SSMS.
(Scott Murray) What Power BI features are available to notify a report consumer of data changes?
(Pinal Dave) The other day while working with a customer during SQL Server Performance Tuning Practical Workshop, I noticed an MDF file with very strange extensions. When I asked the DBA why they have such a large data file with extension PDF (instead of common MDF file extension), he replied that h
(Sergey Gigoyan) Did you ever have a problem handling SQL Server transactions in nested stored procedures? Did you ever receive an error message “Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0.”?
(James Serra) Many product announcements were made this week at Microsoft Ignite, and I wanted to give a quick overview of all the data platform related announcements: