Backups in SQL Server Analysis Services
Analysis Services databases should be backed up at regular intervals like any other database. Here are the basics.
Using the GUI:...
2012-07-24 (first published: 2012-07-19)
2,771 reads
Using Cell-Level Encryption in SQL Server
Industry guidance such as the Payment Card Industry Data Security Standard (PCI-DSS), Healthcare Insurance Portability and Accountability Act (HIPAA) and...
2012-07-19
15,729 reads
The Mentoring Experiment–New Call for Mentees
With both Steve Jones and I done with our summer break, we’re ready to continue with several experiments we’ve been...
2012-07-23 (first published: 2012-07-19)
2,572 reads
Should Apps Use a Dedicated Port?
Most applications connect on whatever the default port is, typically 1433 for SQL, though it’s common to change that to...
2012-07-24 (first published: 2012-07-18)
1,979 reads
Scrum what are story points
In this blog post I discuss Scrum (agile development methodology) and method to accurately estimate effort to complete sprint which...
2012-07-18
725 reads
SSRS does not require IIS
Starting with SQL Server Reporting 2008 Reporting Services (SSRS) was the removal of the Internet Information Services (IIS) dependency, so you do...
2012-07-18
7,607 reads
#TSQL2Day – A Day in the Life of A Service DBA
Today I am excited to join in with my #sqlfamily and participate in this months #tsql2day throw down. This month Erin...
2012-07-18
457 reads
Where in the World is…
You may or may not have noticed that over the past several months I have been somewhat absent from my blog. Very few articles if any have been produced....
2012-07-18
10 reads
Where in the World is…
You may or may not have noticed that over the past several months I have been somewhat absent from my...
2012-07-18
943 reads
What’s been happening in Wayne’s World
Late last year, my life got strange. Well, it’s always been strange, so let’s just say it became stranger than...
2012-07-18
751 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Alamat BCA KCP Metro Pasar Baru Telp:0821°8200°203
Telp/Wa 628218200203 Gedung Metro, Jl. Samanhudi No.103 Lt. Dasar No. 101, 102, Ps. Baru,...
Alamat BCA KCP Kyai Caringin Telp:0821°8200°233
Telp/Wa 628218200233 Jl. Balikpapan No.21 A-B, RT.9/RW.6, Petojo Sel., Kecamatan Gambir, Kota Jakarta Pusat,...
Alamat BCA KCP Tanah Abang Blok A Telp:0821°7555°651
Telp/Wa 628217555651 Pasar Regional Tanah Abang, Kios No.F-081 Blk A Basement I/G-063, F-080, Kp....
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers