Hack Resistant?
Can we make a hack resistant database? A vendor claims this, but Steve Jones thinks it's not really a good claim to make and that we ought to make it our job to secure databases.
Orphaned Distribution Transactions
Learn about orphaned distribution transactions in SQL Server and how you can clear them.
Encrypting and Decrypting SQL Server Stored Procedures, Views and User-Defined Functions
Some companies put business or application logic in SQL Server using stored procedures, views and functions to return values to the calling applications or perform tasks. This is not unusual in companies that use the SQL Server layer to perform business tasks, such as finance operations, or incorporate application functionality into the programmability layer. Here's a tip to preserve secrecy on some procedures, views or functions in order to maintain security.
SQL Saturday #231 Cocoa Beach
Join us for a free day of SQL Server training and networking on July 27 in Cocoa Beach, Florida.
Parameter Sniffing and Sniffing Memory
This article aims to demonstrate bad parameter sniffing and its effects on memory grants.
The Desktop
Steve Jones talks about laptops and desktop machines, and the potential issues that IT professionals have with one or the other.
Using DAX to retrieve tabular data
Data Analysis Expressions (DAX), originally the formula language for PowerPivot workbooks, can also be used within the MDX query window of SSMS to directly access data from a tabular SSAS database, an in-memory database that uses the xVelocity analytics engine and compression. Robert Sheldon shows how easy it is to retrieve data from a tabular database.
Sending E-Mail from SQL 2008 Express
This article provides a comprehensive solution to sending email from SQL Express 2008 and Express 2008 R2.
The Vacation Struggle
It can be hard to take all your time off each year and Steve Jones is in that situation right now. However he reminds us that life is more important than work.
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers