SQL Server Synonyms
SQL Server synonyms can be used to permanently alias database objects in the same or another database. In this article, Greg Larsen demonstrates how to use synonyms and the many reasons to consider using them.
2020-10-20
SQL
The Social Impact of Artificial Intelligence and Data Privacy Issues
Like any technology, AI can be used for evil instead of good. Shree Das explains several examples and what should be done to prevent the misuse of data.
2020-10-05
How SQL Prompt Improves SQL Server Database Development
While everyone knows SQL Prompt for its code completion and IntelliSense features, a lot of its extra value comes from features that allow the development team to standardize coding practices and drive up code quality.
2020-09-29
Execute on DMVs without user having View Server State
Wanted to share this script to the community just in case anyone out there may be search for a way to allow a hosted customer the ability to query certain DMVs for information without granting them View Server State. There are some other options out there, but this worked better for me after going through […]
2020-09-24
2,045 reads
Hands-On with Columnstore Indexes: Part 4 Query Patterns
All queries run fast against columnstore indexes, right? In this article, Edward Pollack demonstrates some query patterns that don’t perform well and how to get around the issues.
2020-09-24
Understanding SQL Server Recovery Models
The database recovery model controls how a SQL Server database can be backed up and restored. In this article, Greg Larsen explains the three recovery models and what to think about when choosing a recovery model for a database.
2020-09-21
Heaps in SQL Server: Part 3 Nonclustered Indexes
Uwe Ricken continues his series on heaps. This time he demonstrates a common scenario where the query against a heap is faster than a clustered index.
2020-09-17
SQL Server Wait Stats Monitoring with PowerShell
In this article we add another module to the PowerShell monitoring process to capture wait stats for all monitored SQL Server instances.
2020-09-15
Storage 101: The Future of Storage
Robert Sheldon wraps up his series on storage by discussing the latest storage innovation and ideas.
2020-09-14
The Two Ways Containers Will Revolutionize Database DevOps
Containers have already transformed the way application development works, but adoption has been slower for databases. Finally, the revolution is beginning. In this post, Kendra Little shares the two ways in which containers will dramatically change the way teams develop and deploy database changes.
2020-09-10
Blogs
Advice I Like: Experience and Aptitude
By Steve Jones
Experience is overrated. Most breakthrough accomplishments were done by people doing them for the...
Plan Time for Self-Development
By Brian Kelley
As you begin the new year, if you don't already have time set aside...
BK’s Bookshelf: Never Split the Difference
By Brian Kelley
I picked up Never Split the Difference: Negotiating As If Your Life Depended On...
Forums
Insiders Selling Data
Comments posted to this topic are about the item Insiders Selling Data
Join 2 tables
Table A ServerName ColB ServerA C ServerA I ServerA L ServerA M ServerA N...
Impact of Not Including Foreign Keys in an SQL Archive Database
Hello everyone, I am about to start a data archiving project that will affect...