Custom Navigation controls in SharePoint 2010
There are several ways to create a custom navigation control in SharePoint. In the below image you can see the...
2013-08-05
928 reads
Custom Coding in SQL Report Services
Reporting Services 2008 is a very powerful tool for creating reports. It contains many different tools and even allows you...
2013-07-29
711 reads
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
960 reads
SSAS Joining Facts at Different Granularities
In an SSAS cube you sometimes need to connect a dimension at a different granularity than other dimensions. For example,...
2013-07-19 (first published: 2013-07-15)
2,123 reads
Report from a Cube in Reporting Services
Data warehousing has become a staple of businesses to help make business decisions. From these data warehouses you can develop...
2013-07-10 (first published: 2013-07-08)
2,675 reads
Create a Named Set with all but one Member in MDX – SSAS
I was trying to create a Named set in SSAS 2008 using the MDX calculations. I wanted to include all...
2013-07-05 (first published: 2013-07-01)
1,678 reads
Comparing Previous Rows in SQL
I had a client recently that needed me to get the direction a student’s GPA was headed on a regular...
2013-06-24
735 reads
Pivoting weird data in SSIS – Sort of…
Sometimes we get data in some bad forms. For example look at the below table:
The names and the amounts are...
2013-06-18 (first published: 2013-06-17)
2,057 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,682 reads
AS400 Program from SSIS
If you need to call an AS 400 program from an SSIS package this can easily be accomplished with an...
2013-06-03
999 reads
Blogs
Can You See Table Valued Parameters in Extended Events?
I live for questions and this was an interesting one. Can you see Table...
Can an AI Help Me Find a Job?
By Steve Jones
I’m not looking for a job, but I ran across an article about using...
EightKB 2025
EightKB is back! The biggest online SQL Server internals conference is back in 2025…it’s...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Pitfalls to avoid while feeding events into CrowdStrike
Comments posted to this topic are about the item Pitfalls to avoid while feeding...
Column Adds and Drops
Comments posted to this topic are about the item Column Adds and Drops
Question of the Day
Column Adds and Drops
I run this batch on SQL Server 2022. What happens?
ALTER TABLE dbo.Accounts ADD AccountAccessType INT GO ALTER TABLE dbo.Accounts DROP AccountAccessType GOSee possible answers