The code in this tip will show how to use two system stored procedures to identify all iterations of a given string in the available SQL Server error logs since a specific point in time.
2014-01-23
3,148 reads
It is ironic that one of the most essential of statistical aggregations, the median, has been so difficult in the past to calculate efficiently in SQL. Dwain Camps sets the candidates to work and identifies the winners and losers.
2014-01-22
3,927 reads
Marcin Policht shows you how to migrate on-premise data that is already cloud-compliant to Windows Azure SQL Databases by converting it into a BACPAC formatted file.
2014-01-21
4,099 reads
DBAs regularly need to keep an eye on the error logs of all their SQL Servers, and the event logs of the host servers as well. When server numbers get large, the traditional Windows GUI approach breaks down, and the PoSH DBA reaches for a PowerShell script to do the leg-work.
2014-01-20
3,050 reads
A DBA Library: it's not the library in traditional terms where you have books and journals stacked on your desk; rather it's a centralized and integrated repository of knowledge, information and applications for the DBA.
2014-01-17
4,700 reads
There is nothing mysterious about SQL Server backups. They are essential, however you use your databases. Grant Fritchey explains the basics of database backups and restores with SQL Server 2014.
2014-01-16
4,252 reads
The new SQL Server 2014 “Memory Optimization Advisor” tool helps you quickly analyze tables to see how easy it is to migrate them to In-Memory OLTP tables. Read on to learn more.
2014-01-15
2,292 reads
The process of doing SQL code-reviews used to be tedious and error-prone. Until SQL Enlight, it was a process that was difficult to automate for release and deployment. As it is now both a Command-line utility and an SSMS add-in, the database developer can see immediately the parts of the code that would raise eyebrows with the vigilant production DBA.
2014-01-14
4,134 reads
Agile methodologies work well with database developments only if great care is taken to do things right. It requires good judgement and leaves little room for error. Dev Nambi, in an extract from the book Tribal SQL, argues that Agile works for smart, curious, and experienced software engineers.
2014-01-13
5,036 reads
This is a very simple script can be used as a framework for you to stop and start your VM’s on Azure with Powershell.
2014-01-10
3,020 reads
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
By Kamil
Managing Microsoft Fabric at scale quickly becomes painful if you rely only on the...
2025 exposed a growing gap between AI ambition and operational reality. As budgets tightened...
Comments posted to this topic are about the item Celebrating Tomorrow
Comments posted to this topic are about the item SQL Art: I Made a...
I am using ssrs in visual studio 2022, I work on a report, there...
Which of these is more appropriate for tomorrow?
See possible answers