Creating a Rolling Date Range Named set in MDX
One Client I was working with wanted a named set that would give them the last 5 years. Of course...
2013-07-22
1,010 reads
Generic Dynamic SQL Stored Procedure
Recently I came across a post on http://www.StackOverflow.com that basically asked how to write a generic stored procedure to handle...
2013-07-31 (first published: 2013-07-22)
3,637 reads
SQL Saturday Orlando – My First Presentation!!!
I’ve submitted presentations before to CodeCamp and SQL Saturdays before, but have never been selected to present due to terrible...
2013-07-21
295 reads
SQL 2012 SSIS Catalog Permissions
With the introduction of the SQL 2012 SSIS Catalog there has been the question of what permissions are available and...
2013-07-20
1,093 reads
Security Cameras in the Neighborhood
I live in a pleasant, calm, middle class neighborhood. Not much crime here, at most the rare break-in or vandalism,...
2013-07-19
727 reads
Energy news that caught my eye
I’ve been a big fan of nuclear energy ever since I worked at a power plant. Before that I was...
2013-07-19
998 reads
More on Finding Bad Links On Your Blog
Yesterday I mentioned using the Google Webmaster Tools to identify some bad URL’s here on the blog. I decided to...
2013-07-19
638 reads
Best SQL Server Podcast and Video Sites (Hangout)
My friend Boris Hristov (Blog | Twitter) continues his Google Hangouts initiative, and this week he invited me to talk about...
2013-07-19
3,214 reads
Audio and slides are up for my webinar on SQL Server encryption
The webinar audio and slides/demo scripts are up for the presentation I did for the PASS Security virtual chapter.
PASS Security...
2013-07-19
759 reads
Rebuilding server level collation setting
Scenario You have just completed setting up a new development database server for a new project. After that, everyone in...
2013-07-26 (first published: 2013-07-19)
1,830 reads
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
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...
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