Using Big Data to Improve Health
With the help of a database that provides fully representative data, we can do a great deal more to advance medical and pharmaceutical science. Phil Factor explains what stands in our way.
Learn the fundamentals of Redgate Products
Redgate invite you to look around their newly refurbished University. If you are new to their tools there are simple, easy to follow courses to get you up and running, and if you are a long-time customer you can check out the recently added courses which take you through some more technical tips, tricks and troubleshooting
SQL Server Permissions List for Read and Write Access for all Databases
In this tip we look a script to find SQL Server logins and database users that have read or write access to any database in the instance.
A Good Reason to use a VCS
Steve has a good reason to use a version control system. It's a different kind of backup that you might need.
How to Stop a SSIS Package Execution from Code
In this tip we look at a way to stop the execution of a SSIS data flow task that is running by executing an outside process to stop the data flow immediately.
Beware, More Ransomware is Coming
Ransomware has become a large problem in the last few years, and Steve thinks this will continue to increase because of insurance payouts.
Backup Techniques Available Exclusively When Using Azure VMs
Learn backup techniques available exclusively when using Azure VMs to host SQL Server-based workloads.
What You Should Know About Coding
Today Steve thinks about the skills and approach we ought to be taught before we start building software as a career.
Partitioning Data in SQL Server without using Partitioned Tables
In this we look at how we to quickly split up data from a SQL Server table into relatively equal size buckets.
SQL Server 2019 Graph Database and SHORTEST_PATH
With SQL Server 2019 on the way, it’s time to begin learning about all the new features. In this article, Dennes Torres demonstrates how to use the new SHORTEST_PATH function that is part of the Graph Database feature.
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
Alamat BCA KCP Pasar Minggu Telp:0821-8200-233
Telp/WA 62 821-8200-233 Jl. Raya Pasar Minggu No.6, RT.6/RW.8, Kalibata, Kec. Pancoran, Kota Jakarta...
Alamat BCA KCP Pejaten Telp:0821-8200-203
Telp/WA 62 821-8200-203 Ruko, Jl. Pejaten Mas Raya Jl. Raya Pasar Minggu No.Km.20 No....
Alamat BCA KCP Tebet Timur Telp:0821-8200-174
Telp/WA 62 821-8200-174 Jl. Tebet Timur Dalam Raya Blok GG No. 97, RT.3/RW.6, Tebet...
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers