SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Latest Blog Posts

SQL Server – Reading BACPAC Files

If you have been reading my blog for a while now you would know that a common technique to move to Azure SQL DB is to use BACPAC files. Just a reminder, see the below image. I had a bacpac … Continue reading

Read more

0 comments, 57 reads

Posted in All About SQL on 19 October 2018

Contextual views Part II or how to hide sensitive data

In this article I continue to explore the ways to secure the data via contextual views and describe the technique of hiding the data in the logical layer utilizing business rules. Click here to read full article.

Read more

0 comments, 103 reads

Posted in SQL Design Patterns on 18 October 2018

Pagination pattern or how to fetch a large dataset for a web report.

In this post we will discuss on how to add ability to fetch data from a large dataset for web applications using pagination technique. Click here to read full article

Read more

2 comments, 127 reads

Posted in SQL Design Patterns on 17 October 2018

Fix SQL Server with one click

Tempting headline, isn’t it? It might even seem like clickbait, but that’s not the intention. The SQL Server default configuration is not recommended for production environments, and yet I have worked on many production environments that have been set up by people who don’t know that the default configurations are… Read more

1 comments, 122 reads

Posted in Born SQL with Randolph West on 17 October 2018

Invalid value given for parameter PASSWORD. Specify a valid parameter value.

I still use sp_help_revlogin to transfer logins between servers.  I know there are other options, including a set of Powershell commands contained in dbatools (#YouCanDoAnythingWithPowershell) but this is a case where the old method works so I don't mess with it.


Having said that, I know a lot of…

Read more

0 comments, 82 reads

Posted in Nebraska SQL from @DBA_ANDY on 17 October 2018

What is the Object Explorer Details tab good for?

For a long time there I would see the Object Explorer Details tab show up when I opened SSMS (SQL Server Management Studio) and I would immediately close it. I couldn’t think of a single use for this view that seemed to be just another way to see the list… Read more

0 comments, 88 reads

Posted in SQLStudies on 17 October 2018

How to Start Speaking

At the last few events I attended, I’ve gotten into conversations on how to begin as a speaker. So I thought I’d share some of my advice that I provided to them.

First and foremost, get your first talk scheduled. Reach out to your local user group and ask to… Read more

1 comments, 86 reads

Posted in SQLEspresso on 17 October 2018

Test post

Test post

Read more

0 comments, 81 reads

Posted in SQL Server Blog Forum on 17 October 2018

Lookup. Foreign Key Constraint vs Check Constraint

This post helps in deciding between choosing foreign key and check constraints in case we need to constraint the data in a field. Click here to read full article

Read more

1 comments, 147 reads

Posted in SQL Design Patterns on 16 October 2018

Extended Events Made Easy – Sorting, Grouping and Aggregation

When I’m using Profiler to analyse performance issues I often save the results to a table, or upload a trace file into a table, so that I can analyse the data. Often this involves aggregating the values for particular queries so that I can see the most resource hungry.

This… Read more

0 comments, 123 reads

Posted in Matthew McGiffen DBA on 16 October 2018

Azure SQL Database Hyperscale

At Microsoft Ignite, one of the announcements was for Azure SQL Database Hyperscale, which was made available in public preview October 1st, 2018 in 12 different Azure regions.  SQL Database Hyperscale is a new SQL-based and highly scalable service tier for single databases that adapts on-demand to your workload’s… Read more

1 comments, 133 reads

Posted in James Serra's Blog on 16 October 2018

A Play Around With Table Variable Deferred Compilation in SQL 2019

Table variables, they’re nasty, dirty little things that perform about as well as a Robin Reliant in a crosswind, right?  Well you’re not going to have me argue with you there.

But how many of us have got these little beasts floating around in their production code with absolutely nothing… Read more

0 comments, 100 reads

Posted in SQL Undercover on 16 October 2018

Conditionally Returning Rows Based On Query Results

While I normally prefer formatting my query results in a downstream app/reporting layer, sometimes I can’t get around adding some business formatting logic to my SQL queries.

Today I want to show you four different ways to conditionally output rows of data based on a SQL query.

Setting Up The…

Read more

0 comments, 98 reads

Posted in Bert Wagner on 16 October 2018

Query Memory Grants and Resource Semaphores in SQL Server

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

In today’s blog posting I want to talk about Query Memory in SQL Server, and want to… Read more

1 comments, 128 reads

Posted in Klaus Aschenbrenner on 16 October 2018

Internal Query Processor Error Debugged

In Joyful Craftsmen we provide, among other things, technical support to our customers, which from time to time involves us in very interesting cases. One of them occurred after a migration of a critical stock trading system database to SQL Server 2017. Every night, when there are no trades on… Read more

0 comments, 141 reads

Posted in Joyful Craftsmen Blog on 16 October 2018

Database Transaction log file full in the full recovery model

I am seeing in more environment the database recovery model is set FULL and there is no transaction log backup scheduled and the log files are growing bigger, until it reaches a file system space.

Me: Hello sir, May I know the reason, why we set the database in full… Read more

0 comments, 90 reads

Posted in SQL Server Blog Forum on 16 October 2018

Speaking at SQL Saturday Oregon

I am so excited and honored that I have been selected to speak at SQL Saturday Oregon on November 3, 2018.

I will be presenting my Data Types Do Matter session at 10:15 am.  I am so excited to be presenting to a kind of “home town” crowd.  I lived… Read more

0 comments, 112 reads

Posted in SQL Swimmer on 16 October 2018

Power BI Monthly Digest – October 2018

In this month’s Power BI Digest with my friend Manuel Quintana [Blog | Twitter] and I will again guide you through some of our favorite Power BI updates this month. In our October 2018 edition we highlighted the following features:

    • Search in Filter
    • DAX Editor Improvements
    • Column Profiling…

Read more

0 comments, 201 reads

Posted in Devin Knight on 15 October 2018

Regular Expressions: tagging expressions

I re-discovered something very cool while using RegEx in SSMS today: tagging expressions and referencing them in the same line! I’ll take a minute to define regular expressions, explain tagged expressions, and then show you how to use it in the same line. But first, XKCD: Regular Expressions defined “A… Read more

0 comments, 104 reads

Posted in SQL Awesomesauce on 15 October 2018

SQL Pivot and Unpivot relational operatots

In this article, we’ll walk-through the SQL Pivot and SQL Unpivot operators and how they can be useful to transpose SQL Server data. Also, we’ll discuss both static and dynamic ways to use PIVOT and UNPIVOT relational operators that can … Continue reading

Read more

0 comments, 98 reads

Posted in PowerSQL By Prashanth Jayaram on 15 October 2018

Older posts