Make an SSIS package Delay or Wait for Data
Packages can be scheduled to run at a time when you expect data to be in a database. Instead of...
2014-07-30 (first published: 2014-07-21)
12,808 reads
Blog Posts
PASS SQL Saturday in Parma
This year, 22 November, PASSSQL Saturday will come to Parma, my birth town. I’m proud to be the organizer of that event.Our community,...
2014-07-30
959 reads
Please open this page in the Admin panel only
I am taking a slight deviation from the usual type of posts that I share. This time, I just want...
2014-07-30
1,396 reads
Please open this page in the Admin panel only
I am taking a slight deviation from the usual type of posts that I share. This time, I just want to share a quick and easy fix that I...
2014-07-30
3 reads
Quick Tips–SQL Prompt Custom Aliases
I love SQL Prompt, and think it’s a great productivity tool. Even before I worked at Red Gate, I love...
2014-07-30 (first published: 2014-07-24)
8,039 reads
This Week in Awesome – Running at PASS, Cookie Jail, SQL Sats, Breakfast
If you’re in Seattle the week of November 2 – say, for example, you’re attending the PASS Summit that week – consider...
2014-07-30
1,030 reads
Clustered Columnstore Indexes – part 36 (“Maintenance Solutions for Columnstore”)
Continuation from the previous 35 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
At the 12th Edition of SQLBits around 1 week ago I have...
2014-07-29
612 reads
Find Users Logged Into Remote Computer
Have you ever wanted to find out if someone is logged into a computer or maybe who is logged into...
2014-07-29 (first published: 2014-07-23)
10,188 reads
Rename or Change SQL Server Standalone Named Instance
Today, We will go through with the steps of renaming or changing SQL Server Standalone Named Instance. Renaming or Changing SQL Server Standalone Named Instance is almost same as...
2014-07-29
5 reads
SSRS report subscription: Fire Event from SSIS package
My previous two posts about SSRS reports being deployed to a SharePoint site along with their subscription didn't stop me...
2014-07-29 (first published: 2014-07-22)
14,498 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers