Friday Followup For June 13, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-06-13
440 reads
Query backup history
As a quick script tip for today I'll show you a script I use regularly for reporting purposes.
It shows you the...
2014-06-13
18,057 reads
SSIS Lessons Learned, Or Not, And Mistakes Beginners Make
It’s been a while since I’ve used SSIS for anything of substantial complexity, and a lot longer than that since...
2014-06-12
801 reads
Spring may be long gone but you still need to clean up MSDB
System databases are often neglected, part of this is due to Microsoft’s message of SQL Server will run and look...
2014-06-12
1,107 reads
Giving Away Woodworking Magazines
I read a lot and one of the topics I enjoy reading about is woodworking. Recently I’ve been on a...
2014-06-12
633 reads
Happy Anniversary!
Today, http://mssqlfun.com/ completed 2 precious years with your support & acknowledgment. It’s wonderful time enriched with fun & learning.
Please keep liking us...
2014-06-12
770 reads
SQL Server 2012 Service Pack 2 (SP2) RTM Is Now Available !
SQL Server 2012 Service Pack 2 (SP2) RTM is now available for download at the Microsoft Support site. Service Pack...
2014-06-12
1,502 reads
Mainstream Support Ending Soon || SQL Server 2008 and SQL Server 2008 R2
Microsoft declares to release last & final service packs for SQL Server 2008 and SQL Server 2008 R2 very soon.
Mainstream Support...
2014-06-12
932 reads
What is this default trace you speak of?
I frequently see the default trace mentioned in answers to forum questions, blog posts, articles, even training sessions. My knowledge...
2014-06-12
849 reads
Win a Free Copy of my Book - Getting Started with SQL Server 2014 Administration
Readers of my blog would be pleased to know that I have teamed up with Packt Publishing and we are...
2014-06-12
726 reads
Blogs
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
Forums
BCA KCU BLOK A CIPETE Telp:0821-8200-233
Telp/Wa 62 8218200233 PQHX+93W, Jl. RS. Fatmawati Raya No.6 A, RT.1/RW.5, Cipete Sel., Kec....
Alamat Kantor BCA KCP Tebet Telp:0821-8200-203
Telp/Wa 62 8218200203 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N &...
Alamat BCA KCP Tebet Barat Telp:0821-8200-174
Telp/Wa:62 8218200174 Jl. Tebet Barat IX No.40, RT.6/RW.4, Tebet Bar., Kec. Tebet, Kota Jakarta...
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