Pulling real-time data from Twitter using StreamInsight
An example of building a StreamInsight input adapter for retrieving Twitter data in real-time.
Report Customization - Level 8 in the Stairway to Reporting Services
This article discusses how to create custom functions, methods, and expressions so that you can make your data do things that Reporting Services won't!
SQL Server Dynamic Online Catalog: Why Should You Care? Stairway to Exploring Database Metadata Level 1
In this first level, we look at the overview of what metadata is contained in each database, gain some understanding of the different types of information, and examine a few basic examples.
SSRS In a Flash - Level 1 in the Stairway to Reporting Services
Learn the basics of Reporting Services, what it is, and what it can do from you. From MVP Jessica Moss, we have a new series that can help you get started with this part of SQL Server.
SSRS In a Flash - Level 1 in the Stairway to Reporting Services
Learn the basics of Reporting Services, what it is, and what it can do from you. From MVP Jessica Moss, we have a new series that can help you get started with this part of SQL Server.
Stairway to Biml Level 3: Building an Incremental Load Package
The Stairway to BIML continues, with a lesson on how you might build a more complex package: an incremental load package.
Stairway to Biml Level 4: Using Biml as an SSIS Design Patterns Engine
In this level, we make a large leap forward, showing you how to use BIML to script a large number of packages using C#.
Stairway to Columnstore Indexes Level 10: Optimizing Queries For Batch Mode (Part 1)
In this level, Hugo Kornelis looks at how to rewrite your queries to best take advantage of batch mode.
Stairway to Columnstore Indexes Level 11: Optimizing Queries For Batch Mode (Part 2)
Hugo Kornelis continues his exploration of the types of queries that can end up running in row mode when accessing columnstore indexes. He demonstrates how careful rewriting can often yield a logically equivalent query that runs in batch mode instead, and therefore gains the best possible performance benefit.
Stairway to Columnstore Indexes Level 5: Adding New Data To Columnstore Indexes
Earlier levels have shown how Columnstore Indexes work effectively with static data. In most tables however, data is hardly ever static. We are constantly inserting new rows, and updating or deleting existing rows. If you think about what this means for a columnstore index, you will realize that this comes with some unique challenges.
Blogs
VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Free Webinar about Columnstore Indexes
I’m doing a small series on indexing basics for SQL Server, and on May...
Forums
BCA KCU PURI INDAH Tlpn/wa0853.7373-7551
Gedung C3 Lt. 1-3 Komplek, Jl. Puri Indah Raya No.1-3 Blok 02, Kec. Kembangan,...
BCA KCU BINTARO Hubungi Cs.0851•8812•0691
BCA KCU BINTARO Hubungi Cs.0851•8812•0691 Bintaro Jaya Blok A-5 No.12 & 15, Sektor 7,...
BCA KCP Bojong Indah Tlpn/wa0853.7373-7551
Komp. Bojong Indah Cengkareng, Jl. Pakis Raya 88 H, Daerah Khusus Ibukota Jakarta 11740
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers