Simpson's Paradox
This article is a case study and an attempt to explain an interesting phenomenon with data anomalies that is commonly called Simpson's Paradox.
2017-01-10
3,717 reads
Articles
SQL Server 2016 Enterprise Edition Performance Advantages
Glenn Berry uses a few specific examples to demonstrate the performance benefits you can get from SQL Server 2016 SP1 Enterprise Edition.
2017-01-10
4,975 reads
Using R to Identify Key Features Quickly
Typical BI dashboards display data summaries like counts and averages. We use R to extend on these to identify key associations in a dataset.
2017-01-09
2,338 reads
Using SQLite with PowerShell and SQL Server
When you combine PowerShell and SQLite, you can perform powerful magic. Phil Factor is in awe of SQLite and gives a brief demonstration of how easy it is to use. Just to encourage anyone who is unfamiliar with the database, he includes a giant-sized SQLite version of the old PUBS database that the first generation of RDBMS developers cut their teeth on.
2017-01-09
3,904 reads
An Introduction to SQL Server Containers
Get the basics of what a container is and how this can work with SQL Server.
2017-01-06
9,764 reads
How to run SSIS Project as a SQL Job
In this piece by Pilip Horan, learn how to create an SSIS catalog and run a project as a SQL Agent Job.
2017-01-06 (first published: 2015-05-11)
16,436 reads
SQL Server Ad Hoc Access to OLE DB Provider Has Been Denied Error
I was trying to use OPENROWSET to query a remote database and I experienced the following error "Ad hoc access to OLE DB provider has been denied. You must access this provider through a linked server". When I ran this same query using a sysadmin account it worked fine. Why doesn't this work for other logins?
2017-01-06
2,805 reads
Dynamic Data Masking Feature in SQL Server 2016
Microsoft has introduced very impressive new security feature in SQL Server 2016 called Dynamic Data Masking (DDM).Dynamic Data Masking allow user to decide how much of the sensitive data to reveal with minimal impact on the application layer.
2017-01-05
5,023 reads
Questions About SQL Server Security and Access Control You Were Too Shy to Ask
For many developers, database security and Access control is just something that gets in the way of development work. However, several recent security breaches have had devastating consequences and have caused a change in attitude about the value to any organisation of having database applications that meet industry standards for access control and security. The problem, however is in admitting that you have a problem and finding answers to those problems you are just too shy to ask in public.
2017-01-05
7,712 reads
Removing Email from msdb Database
Is your msdb database growing bigger every day? If so you might want to consider purging some of the history records. Greg Larsen explains.
2017-01-04
6,454 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Pasar Puri Indah,Telpon/Wa 0821-8200-239
Blok A, Jl. Puri Indah Raya 20-22, Kembangan Sel., Kec. Kembangan, Kota Jakarta Barat,...
BCA KCP Sanur Raya. Tlp:08218168235
Jl. Raya Jl. Bypass Ngurah Rai No.287, Sanur, Denpasar, Kota Denpasar, Bali 80227
BCA KCP Jatinegara Timur Telpon/WA:087768193341
BCA KCP Jatinegara Timur Telpon/WA:087768193341.Jl. Jatinegara Timur No.37 Pav, RT.8/RW.4, Bali Mester, Kecamatan Jatinegara,...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers