SSIS aggregate transformation
In this SSIS 2012 tutorial we will show you how to use data flow Aggregate Transformation and we will use...
2012-07-25
1,780 reads
Blog Posts
Tampa IT Pro Camp Coming on September 22,2012
The Tampa IT Pro Camp will be held September 22 at New Horizons in Tampa (different location than last time)....
2012-07-25
660 reads
Transact-SQL Script to Monitor Replication Status
Today, I’ve written the following T-SQL script which you can use to monitor the status of transactional replication and performance...
2012-07-25
7,039 reads
Visual Studio 2012 does not support BI
In the same vein as my post Watch out, Visual Studio 2010 does not support BI, Visual Studio 2012 does not...
2012-07-25
16,084 reads
Why You Should Speak at SQLSaturday (Or Any Other Free Event)
I talk to people about career planning and professional development quite a bit. It’s common to find them wanting to...
2012-07-25
1,073 reads
Backups in SQL Server Analysis Services
Analysis Services databases should be backed up at regular intervals like any other database. Here are the basics.
Using the GUI:...
2012-07-24 (first published: 2012-07-19)
2,768 reads
Improve DBA Operation Productivity – Part One
I define DBA operation productivity as the total positive values brought to the work environment by a DBA in a...
2012-07-24
1,088 reads
PowerPivot diagram view missing
Some of you might be wondering why Diagram View is missing in some PowerPivot windows. This is related to Microsoft...
2012-07-24
2,388 reads
Should Apps Use a Dedicated Port?
Most applications connect on whatever the default port is, typically 1433 for SQL, though it’s common to change that to...
2012-07-24 (first published: 2012-07-18)
1,977 reads
SQL 2012 evaluate installation requirements
As part of my preparations for 70-462 Administering SQL Server 2012 today I have created a blog post covering "evaluate...
2012-07-24
1,308 reads
Blogs
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Keeping Track of my ConEmu CLIs
By Steve Jones
I use ConEmu for my terminal interface. I’m still on Windows 10 at home,...
10 Decisions to Make Before You Create A Fabric Workspace
Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...
Forums
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Hyperscale Replicas III
Comments posted to this topic are about the item Hyperscale Replicas III
Development Is Fun
Comments posted to this topic are about the item Development Is Fun
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers