Whether or not to have NULLable columns in a table can be a religious debate, and how missing data is represented should be carefully considered during database design. In this article, Joe Celko considers the ways that SQL Server handles NULLs in several situations.
2019-02-11
3,289 reads
Wait! Before you install that next SQL Server, hold up. Are you sure you’re using the right version?
2019-02-08
4,012 reads
In order to protect data and comply with regulations such as the GDPR and HIPAA, databases used by developers and testers must not contain private and sensitive data from production databases. To help DBAs protect data, Microsoft have released a new feature as part of SSMS called Static Data Masking. In this article, Greg Larsen demonstrates how to use this new feature.
2019-02-07
2,794 reads
Learn how to import data into Power BI using either R or Python scripts.
2019-02-06
2,238 reads
As more dev teams move their code to Git, it’s important to understand the differences between it and other tools they have used in the past. In this article, Michael Sorens provides some good advice about doing code reviews with Git.
2019-02-05
3,221 reads
When most of us think of robotics used in enterprises, automating manufacturing processes comes to mind. Robotics Process Automation (RPA), however, deals with automating mundane office tasks. In this article, Arvind Kumar explains the benefits of RPA and presents a case study.
2019-02-04
2,164 reads
How much do database administrators, analysts, architects, developers, and data scientists make? We asked, and 882 of you from 46 countries answered this year. Y’all make a total of $84,114,940 USD per year! Hot diggety. (And at first glance, it looks like on average, y’all got raises this year.)
2019-02-01
4,009 reads
Journalist Alamzeb Khan discusses recent security breaches in Pakistan that have affected millions of people and accounts.
2019-01-31
3,554 reads
In this tip we look at how to cleanup the SQL Server query store after a database has been restored to ensure that query store starts data collection starts fresh.
2019-01-30
2,074 reads
Transitioning to the Platform-as-a-Service model typically implies relinquishing certain degree of control over your computing environment. One of the primary concerns related to this transition is diminished level of transparency providing insights into performance of cloud-resident workloads. Fortunately, with Azure SQL Database, you have a wide range of options that address this concern, allowing you to identify and remediate overwhelming majority of performance-related issues.
2019-01-29
2,366 reads
By Steve Jones
If it fails where you thought it would fail that is not a failure....
Quite a long title for a short blog post ??While deploying a DACPAC (from...
By Kevin3NF
Some of the best career enhancers you can buy. Why I Go to...
Comments posted to this topic are about the item A Place where AI Technology...
What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?
SELECT OBJECT_DEFINITION (OBJECT_ID(N'dbo.uspGetBillofMaterials')) AS [Object Definition]; GOSee possible answers