Create stunning visualizations with Power View in 20 minutes or less!
Learn about Microsoft’s latest end-user BI reporting tool, Power View, and create animated graphs that impress your boss!
2016-04-29 (first published: 2014-12-30)
12,992 reads
Articles
Write for SQLServerCentral - Bonus for Azure
We're always looking for articles, but here are a few ones that I'd like to see written up.
2016-04-29 (first published: 2014-09-04)
1,987 reads
Questions About PowerShell Basics That You Were Too Shy To Ask
Developers who are already familiar with application languages will be baffled by different aspects of PowerShell to the beginner to programming. Laerte recalls his initial struggles with PowerShell and answers those questions he wished he'd found quick answers to.
2016-04-29
4,782 reads
Azure SQL Database Elastic Database Jobs
In this article, Marcin Policht describes the basic functionality and implementation steps for Azure SQL Database's Elastic Database jobs.
2016-04-28
5,096 reads
Data Mining Part 38: Text Mining - The term lookup
In this new article, we will show how to use the SSIS term lookup transformation tool.
2016-04-27
1,996 reads
How to change server level collation for a SQL Server Instance
Manvendra Singh explains step by step how to change the server level collation setting for an existing SQL Server instance.
2016-04-27
3,428 reads
SQL Server Resource Governor
Using Resource Governor on a SQL Server that suffers from CPU contention thus allowing us specify limits on the amount of CPU that an incoming request can use.
2016-04-26
3,722 reads
The Practical Problems of Determining Equality and Equivalence in SQL
In theory, it is easy to determine whether data is equal to, greater than or lesser than a value. Real-world data types can be surprisingly tricky, even for gauging data equivalence. Because SQL cannot remain aloof from any application's data types, you need to be aware of the ways and pitfalls of individual datatypes and how you can test for equality, equivalence, similarity, identity and all that jazz. Joe Celko discusses.
2016-04-26
4,566 reads
Verify SQL Backups With SQL Powershell
With SQL Powershell, you can check all your database backups in minutes, whether you have ten SQL servers or 100.
2016-04-25
5,472 reads
Knee-Jerk Performance Tuning: Incorrect Use of Temporary Tables
Paul Randal continues his knee-jerk performance tuning series, focusing on ways to optimize performance when using temporary tables.
2016-04-25
6,231 reads
Blogs
Questions and Answers from Running a Local LLM
By Steve Jones
I had a few random questions from my Running a Local LLM on Your...
Overview of Claude AI Models: Which One to Choose?
By Arun Sirpal
For those entering the AI space whether professionally or personally I wanted to give...
Houston AI-Lytics 2026–Powerpoint Slides
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
Forums
SSIS package failing intermittently on last Excel Component
Good Afternoon, I have a Job which "fires" off an SSIS package (that is...
T-SQL in SQL Server 2025: JSON_ARRAYAGG
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Spring Connections and Learning at PASS On Tour
Comments posted to this topic are about the item Spring Connections and Learning at...
Question of the Day
Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers