SQLCLR is now considered a robust solution to the few niche requirements that can't be met by the built-in features of SQL Server. Amongst the legitimate reasons for avoiding SQLCLR, there is the fear of getting bogged down in code with special requirements that is difficult to debug. Darko takes a real example, extending the features of sp_send_dbmail, to demonstrate that there need be few terrors in SQLCLR.
Lots of work is going into making software more helpful. This week Steve Jones wonders what you want from these assistants.
OPENQUERY arrives with a lot of baggage. Try this alternative technique to inserting stored procedure results into a new table.
Excel and Power BI work well together. This allows you to use the two tools together to provide for many types of business workflow and BI practices. You can publish an Excel file to Power BI to share with others, analyse a Power BI dataset in Excel or import either an Excel workbook or Excel data to Power BI. You can gain the workgroup power and business-orientation of Power BI without losing the ease and versatility of Excel. Saurabh shows how.
Step-by-step instructions for downloading and installing SQL Server Data Tools (SSDT) for SQL Server 2016.
Today Steve Jones talks about the tipping point of cloud computing.
Are you purging the old database mail items stored in msdb? In this tip, Greg Larsen shows you how to purge database mail.
While thinking about interviews, Steve Jones shares a story of a job situation he encountered.
Automate your Data Lake with PowerShell! Learn how PowerShell can be used to execute U-SQL scripts, as well as a few other little tricks.
Any DBA who is trying to find the cause of an intermittent problem with a server or database dreams of being able to use a query or procedure take a snap of the relevant variables at the point when the problem occurred. Laerte takes an example of a slow-running query hogging resources to show that you can run queries when a WMI alert is fired, and save the results for later inspection, whenever it happens.
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Jl. Wolter Monginsidi No.54, Petogogan, Kec. Kby. Baru, Kota Jakarta Selatan, Daerah Khusus Ibukota...
Call Center Batik Air Yogyakarta dapat di lakukan menghubungi CS resmi Batik Air di...
Call Center Batik Air medan dapat di lakukan menghubungi Layanan resmi Batik Air di...
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers