T-SQL Tuesday #104: Just Can’t Cut That Cord
We all have our favorite scripts, tools or utilities. Those are the things that help make our jobs easier. Some...
2018-07-20 (first published: 2018-07-10)
2,186 reads
We all have our favorite scripts, tools or utilities. Those are the things that help make our jobs easier. Some...
2018-07-20 (first published: 2018-07-10)
2,186 reads
We all have our favorite scripts, tools or utilities. Those are the things that help make our jobs easier. In this article, I share with you a poor mans...
2018-07-10
2 reads
Conquering Challenges
Months ago, I posted an article about some of the challenges encountered while migrating from one service level to...
2018-07-06
745 reads
Migrating a wordpress blog comes with its various set of challeneges. This installment covers magically changing percent symbols during that migration.
Related Posts:
Summiting that Technical Challenge January 9, 2018
T-SQL...
2018-07-06
One of the tasks I find myself doing on a fairly regular basis is running SSMS as a different Windows...
2018-07-06 (first published: 2018-06-28)
2,684 reads
Runas should be a very common tool in the toolbox of all IT professionals - not just Data Professionals. Learning how to test different accounts is essential to being...
2018-06-28
217 reads
In a recent article, I took you on a trip through how to hack (ethically) a SQL Server to regain...
2018-05-31
554 reads
Starting SQL Server in single-user mode should be a tool every data professional holds in the bag. This is an essential tool that can be used in multiple scenarios...
2018-05-31
283 reads
As a data professional can you recall the last time you needed to support a SQL Server instance for which...
2018-05-30
856 reads
Losing access to a SQL instance is never a desirable situation - for the DBA. When the people that are supposed to have access, lose that access, all hope...
2018-05-30
11 reads
pg_cron is a simple cron-based job scheduler for PostgreSQL that runs inside the database...
By Steve Jones
I heard someone say recently that you can’t change a primary key value in...
By Kevin3NF
Indexes 101: What, Why, and When? “What Is an Index?” I get this question...
Comments posted to this topic are about the item 50 Years of Microsoft
Comments posted to this topic are about the item Multiple Collations
Comments posted to this topic are about the item Retrieving Data Using the REST...
Can I have a collation expression like this in SQL Server 2022?
... WHERE ColumnA = ( 'abc' COLLATE French_CI_AS) COLLATE French_CS_AS ...See possible answers