Executing Dynamic SQL Using sp_executesql
Learn how to create and execute dynamic SQL in your SQL Server projects!
2019-08-13
Articles
How to convince your boss you need SQL Server monitoring
You’ve read the State of SQL Server Monitoring Report and you’ve decided you need a SQL Server monitoring tool to cover your estate fully. Now you just need to convince your boss to get on board. Read our blog to find out how to do it.
2019-08-13
Dynamic SQL for beginners in 33 minutes
Learn some of the basics of using Dynamic SQL in a short series of videos.
2019-08-12
8,587 reads
How to boost team productivity with SQL Clone 4
Wednesday August 21 16.00-17.00 BST/ 10.00-11.00 Central - SQL Clone enables dev, test and CI environments to be created and refreshed in seconds, on demand or through self-service, with the latest copy of production data, masked for compliance.
2019-08-12
Measuring the Right Things
In this weeks Simple Talk editorial Kathi Kellenberger discusses how to measure the performance of a development team and why you should always make sure you are measuring the right thing, not just the easy thing.
2019-08-12
Track Sensitive Data with SQL Server Extended Properties
A major priority in our industry today is protecting and tracking sensitive data. See how you can utilize SQL Server Extended Properties to do just that.
2019-08-09 (first published: 2017-11-27)
4,023 reads
Find out exactly what SQL Monitor can save you
Redgate’s SQL Monitor was named the most popular third-party monitoring tool in this year's State of SQL Server Monitoring Report. Find out exactly what SQL Monitor can save you and your company with the ROI calculator.
2019-08-09
Power BI Bubble Map, Shape Map and Filled Map Examples
In this tip we look various map visualizations like Bubble, Shape and Filled Map visualizations you can use with Power BI.
2019-08-09
Some T-SQL INSERTs DO Follow the Fill Factor! (SQL Oolie)
With origins from the world of “Submarine ‘Dolphin’ Qualification” questions, an “Oolie” is a difficult question to answer, or the knowledge or fact needed to answer such a question, that may or may not pertain to one's duties but tests one's knowledge of a system or process to the limit. Introduction Contrary to what many […]
2019-08-08
6,299 reads
PolyBase in SQL Server 2019 – The End of ETL?
PolyBase has been around since 2016, but Microsoft is enhancing it in 2019 with the ability to connect to more data sources. You can now use PolyBase to connect to other SQL Server instances, and it’s easy to set up with a wizard. In this article Benjamin Weissman explains what’s new in PolyBase and walks you through setting it up and connecting to an external table.
2019-08-08
Blogs
Scaling PowerShell – Lessons from a Technical Interview
By gbargsley
Recently, I was in a technical interview where the topic of running PowerShell at...
Installing Old Versions of PowerShell Modules with Their Dependencies
By alevyinroc
I don’t recall where this came up (probably in SQLSlack), but I had a...
In Memory of Andrew Clarke, AKA Phil Factor
By Steve Jones
One of the parts of getting older that really sucks is I seem to...
Forums
how to get notification that my database has corssed 8gb
i have sqlexpress on rds, is there any way i can get notifacation that...
SQL Server, Heaps and Fragmentation
Comments posted to this topic are about the item SQL Server, Heaps and Fragmentation
Stairway to Azure SQL Hyperscale – Level 2: Page Server Architecture Explained
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
Question of the Day
SQL Server, Heaps and Fragmentation
A table without a clustered index (heap) will NOT suffer from fragmentation during frequent updates or deletes. True or False?
See possible answers