How SQL Server 2014 improves Online Operations that aren’t Online Operations
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email...
2014-01-02
1,066 reads
Blog Posts
Master Data Services 2014: Creating nightly load processes
Introduction
A few days ago, I ran into an interesting issue when creating a stored procedure to load new data into...
2014-01-02 (first published: 2013-12-23)
3,508 reads
MCSM (Microsoft Certified Solutions Master) Data Platform on SQL Server 2012
(de)
Einige meiner engsten Kollegen wissen es bereits, und nun teile ich es öffentlich mit:
Seit 31.12.2013 bin ich nicht mehr „nur“
Microsoft...
2014-01-02
1,652 reads
PASS SQLSaturday Events: January 2014
PASS SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please...
2014-01-02
311 reads
Power BI Q&A Preview now works on your data
As I mentioned in Power BI first impressions, Power BI Q&A is an instantaneous search experience that uses a natural language query....
2014-01-02
739 reads
Question of the Week - 2/1/2014 - Question 1
Question :-
Suppose we have to design a database in which employees can work on multiple projects.There are many designation defined...
2014-01-02
549 reads
Reflections on 2013
2013 was a year of incredible growth, change, and challenge for me. This last year has been an amazing roller coaster...
2014-01-02
627 reads
Setting up the Min and Max Memory options on the fly – Word of caution !
Apparently,setting up the Min and Max Memory setting for SQLServer should be definitely encouraged and no server should be left...
2014-01-02
832 reads
Some Thoughts on the Target Breach
Possibly as many as forty million credit cards used at Target were compromised. A staggering breach and a cautionary tale...
2014-01-02
963 reads
SQL Server 2014: Master Data Services Backing up your data models.. A necessary evil !!
Introduction
A few days back, in my article entitled ‘Master Data Services 2014: Creating nightly load processes’, I discussed the setting...
2014-01-02
3,915 reads
Blogs
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
Forums
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers