Last Weeks Top “Reading” Links #36
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-06-10
523 reads
PowerShell – Identify Service Account & Other Details of SQL Services – Multi Server Script
One of my friend requested me to give a mutli server script to pull SQL Service related details. Here is...
2013-06-10
1,744 reads
Praise and a Suggestion for AlwaysOn
One of my favorite additions to SQL Server 2012 is the Availability Groups, referred to as AlwaysOn. These things are...
2013-06-10
819 reads
Building a SharePoint 2013 BI Demo Environment Part 8 – Verifying PowerPivot Integration
After configuring SharePoint in the part 7, we will now verify if the configuration was successful and if everything works...
2013-06-10
4,073 reads
SSRS – Using a Parameter to make Dynamic Columns
Multiple value parameters are a common tools used in SSRS. You can use this tool to select which columns actually...
2013-06-12 (first published: 2013-06-10)
3,697 reads
SQL Server – How to get sizes of all databases on a server
To get database size information we can use sys.master_files catalog view. This view contains a row per file of a...
2013-06-10
1,280 reads
Using the OVER clause
Over the last few years I’ve learned quite a bit about different techniques in SQL Server. This particular one has...
2013-06-10
713 reads
Time to Complete the 2013 BI Survey
It’s that time of year again… end of the school year, graduation, Fathers’ Day and of course; time to take...
2013-06-10
501 reads
SQL Server 2014 Announced
Introduction
A week late and more than a few dollars short, this blog post is focusing on a few of the features announced for SQL Sever 2014. I’ve watched the...
2013-06-10
7 reads
PASS Summit 2013
PASS Summit is the world's largest and most intensive technical training conference for Microsoft SQL Server and BI professionals. But more...
2013-06-09
679 reads
Blogs
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Forums
Understanding Temp Tables and Table Variables in SQL Server
Comments posted to this topic are about the item Understanding Temp Tables and Table...
The Data API Builder MCP Server Tools
Comments posted to this topic are about the item The Data API Builder MCP...
Collecting Data Is Hard
Comments posted to this topic are about the item Collecting Data Is Hard
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers