SQL Script to search stored procedures containing a given text
Sometimes we need to find out how many stored procedures contains a given text. Below SQL query can be used...
2015-01-20
683 reads
Blog Posts
SQLSaturday #362 – Austin, TX – Let’s Get Weird
I used to spend the 4th of July weekend (or week) in Austin with some buddy’s when we were in...
2015-01-20
929 reads
Windows policy Lock Pages in Memory option and SQL Server instance in VM
As we know, this Windows policy Lock Pages in Memory option determines which accounts can use a process to keep data in physical memory, preventing the Windows operating system from paging...
2015-01-20
20 reads
Windows policy Lock Pages in Memory option and SQL Server instance in VM
As we know, this Windows policy Lock Pages in Memory option determines which accounts can use a process to keep data in...
2015-01-20
1,999 reads
A Healthy SQL Server
T-SQL Tuesday has come and gone and I missed the boat due to some ongoing work constraints. With that said...
2015-01-19
569 reads
Exam Prep 70-463: Data Flow Source Adapters
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2015-01-19
893 reads
Part2 Adding a New CheckBox – Create your own SQL tools with PowerShell and Windows forms
Steve:
This is James’ second post on creating SQL tools with PowerShell and Windows forms. James is a DBA responsible for...
2015-01-19 (first published: 2015-01-14)
6,789 reads
T-SQL – How to find Next Business day from a given date
There are many methods to find next business day. One common way is to use of calendar table. This post is to...
2015-01-19 (first published: 2015-01-12)
8,232 reads
Understand the True Source of Problems
There’s an old joke that goes, “Doctor, doctor, it hurts when I do this.” While the person in question swings...
2015-01-19
783 reads
Upgraded SSD
I was going to call this an upgraded HDD, but that’s not right. Technically it’s a drive update, but really...
2015-01-19
2,075 reads
Blogs
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Why companies use Palantir and how we help implement it in the Czech Republic
Palantir is an American software platform that brings together business data from different sources...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Alamat BCA KCP Ponorogo Hub/Wa. 0817-819-444
WhatsApp:0817819444 Rk. Gajah Mada, Jl. Gajah Mada No.12, Krajan, Kepatihan, Kec. Ponorogo, Kabupaten Ponorogo,...
Alamat BCA KCP Sumedang Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Mayor Abdurahman No.181-183, Kotakaler, Kec. Sumedang Utara, Kabupaten Sumedang, Jawa Barat 45322
Question of the Day
SQL Server Audit Failures
If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?
See possible answers