Haunted SQL: The ghost of Management Studio
Have you ever had a query change performance unexpectedly? Intellisense all of a sudden stops working, or gives inconsistent results?...
2017-10-30
684 reads
Kenneth Fisher
Permissions required for developing with Temporal Tables
Temporal tables are one of those new (2016+) cool features that recently came across my desk. Basically, a temporal table...
2017-10-26 (first published: 2017-10-16)
1,864 reads
2017-10-25
429 reads
Schema only backup or schema only DB copy
Every now and again you have a database where you don’t necessarily need the data. It can easily be re-loaded...
2017-10-25
1,185 reads
Updateable CTEs
CTEs are cool things. You can essentially create one or more in-line view(s) within your query. One thing that isn’t...
2017-10-18
1,978 reads
Small identity columns
We frequently talk about dealing with outgrowing INT identity columns. What we don’t talk about all that often is small...
2017-10-17 (first published: 2017-10-09)
1,858 reads
sys.objects VS helper functions (OBJECT_ID, OBJECT_NAME, etc)
I’ve you’ve done much work with the system views (DMVs for example) then you’ve had to translate an object_id into...
2017-10-11
436 reads
The Alpha and the Omega. The BEGIN and the END.
The BEGIN/END block is a fairly standard thing if you’ve ever done any coding, but it never hurts to do...
2017-10-04
962 reads
Haunted SQL
I decided that for Halloween this year it would be fun to tell SQL ghost stories. When I tweeted about...
2017-10-03
346 reads
SQL Homework – October 2017 – Sample/Test Database(s)
Last month your homework was to set up your own lab. Now it’s time to put a sample database or...
2017-10-02
440 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 Lumajang Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Panglima Besar Sudirman No.27, Tompokersan, Kec. Lumajang, Kabupaten Lumajang, Jawa Timur 67311
Alamat Telp BCA KCP Banjar Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Letjen Suwarto No.1A B-C, Hegarsari, Kec. Pataruman, Kota Banjar, Jawa Barat 46322
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