Encrypt and Decrypt Passwords in SQL Server with PowerShell
In this article we look at how to securely store data in text files that could be used for SQL Server authentication or wherever you need to keep data secure.
2021-03-17
SQL Server
Delete SQL Statement in SQL Server, Oracle and PostgreSQL
Learn about the differences and similarities when deleting data from SQL Server, Oracle and PostgreSQL with the several examples in this article.
2021-03-16
Reusing Query Results in SSMS
Every time you need to reuse the query results from SSMS, for example to populate another table, or to search for matching rows in another table, it will inevitably mean a lot of manual tweaking to the get the results into the right format. Louis Davidson uncovers three SQL Prompt gems that can remove all this pain.
2021-03-16
SQL Server authentication methods, logins, and database users
Understanding SQL Server security is a critical skill. Greg Larsen explains SQL Server authentication methods, logins, and database users in this article.
2021-03-15
T-SQL Tips and Tricks
In this article learn some TSQL tips and tricks working with CTEs, UPDATES, Window Functions, Duplicate Rows, Tally Tables and Concatenating string values in SQL Server
2021-03-10
Getting Data In and Out of SQL Server Flyway Builds
Phil Factor provides SQL routines to extract data from and load data into a SQL Server database, using BCP, and then a PowerShell automation script that uses Flyway to automatically build a database, from scratch and then fill it with data, ready for testing.
2021-03-10
SQL Server DBA Utility Dashboard
Create a quick application that stores your favorite queries that you can use to quickly connect to any server and return the results.
2021-03-08
Power BI Small Multiples Visual Example
Power BI has a new feature which is the Power BI Small Multiples visual. In this article we cover how to enable this feature and also walk through an example of how to use this in a Power BI report.
2021-03-05
SQL Server 101 Tutorial
Since its initial release in 1989, SQL Server has come a long way from its base functionality as an enterprise level database platform. While the core of SQL Server is still it's database engine, it is now so much more than just a relational database plat
2021-03-04
Using Azure SQL Data Sync to Replicate Data
Learn how to setup and use Azure SQL Data Sync to synchronize and replicate data from various locations including Azure SQL Database, cloud and on-premises databases.
2021-03-02
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Automating Export of PowerQuery to SQL Server using DAX Studio...?
I wrote a PowerQuery that parses a table from a PDF, and I want...
Attaching an SQL Server database without Transaction Log Files through SQL Server Management Studio.
Comments posted to this topic are about the item Attaching an SQL Server database...
Superseded Indexes
Comments posted to this topic are about the item Superseded Indexes
Question of the Day
Superseded Indexes
Which of these indexes is superseded by another?
See possible answers