SQL and T-SQL for Beginners in 229 minutes
The the basics of SQL and T-SQL in this short course of videos that explain some of the concepts.
Key findings from the State of SQL Server Monitoring
Microsoft MVP Grant Fritchey provides an insight into the key findings from the report; what is the biggest challenge facing database professionals this year? How are estates changing? And what technologies are being used across the industry? Read Grant’s blog to find out.
SQL Server and Excel Hierarchyid Example for Organization Charts
In this tip we look at how to build a hierarchy chart using the SQL Server hierarchyid data type and Excel to format the chart.
Parsing HTML to SQL using SQLDOM
It is simple to parse HTML directly to SQL, manipulate, and render back to HTML using SQLDOM
Politics makes for bad databases - plus calculate British holidays
In this piece, learn about changes in UK holidays and get a script to calculate them.
Ransomware and DevOps
Ransomware is becoming a bigger and bigger problem. Steve has some thoughts on how you should think about security in your database environment.
10 steps you can take to be compliant worldwide – free whitepaper
Learn how data protection legislation is changing around the world and the 10 steps database teams can take to ensure compliance and defend against data breaches.
Reporting Services Basics: Understanding Data Sources and Datasets
Data sources and datasets are critical components of an SSRS report, but many people new to SSRS struggle to understand them. In this article, Kathi Kellenberger shows you how to create these components and explains when they should be shared vs. embedded.
Azure DWH part 20: Create External and Internal tables As Select
CTAS and CETAS are very important T-SQL features in ASDW. These features allow to create a table and fill with data based on a query.
Blogs
Modify Power BI page visibility and active status with Semantic Link Labs
Setting page visibility and the active page are often overlooked last steps when publishing...
T-SQL Tuesday #190–Mastering a New Technical Skill
By Steve Jones
It’s time for T-SQL Tuesday again and this time Todd Kleinhans has a great...
Getting Started with the MSSQL AI Agent in VS Code
By Steve Jones
Recently I was working in VS Code and I saw a walkthrough for the...
Forums
Password Guidance
Comments posted to this topic are about the item Password Guidance
Using table variables in T-SQL
Comments posted to this topic are about the item Using table variables in T-SQL
Azure elastic query credential question
I am trying to check out elastic query between two test instances we have...
Question of the Day
Using table variables in T-SQL
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers