Granting View Definition Permission to a User or Role in SQL Server
In SQL Server 2005 by default users of a database that are only in the public role cannot see the definitions of an object while using sp_help, sp_helptext or the object_definition function.
How to Resize tempdb
When you are setting up a new SQL Server machine you need to determine how big you should make tempdb. To make sure you size tempdb appropriately you should monitor the tempdb space usage. If there are autogrowth events occurring after you have recycled SQL Server than you might want to increase the size of your tempdb data files. If tempdb never uses most of the tempdb space, then you might want to consider decreasing the size of tempdb.
Data Has a Dollar Value
Data in our systems has an actual dollar value, which we might be aware of if we have to purchase more.
Power BI Introduction: Power Query M Formula Language in Power BI Desktop — Part 6
In this article of the Power BI series, Robert Sheldon demonstrates how to work with the Power Query M language to import and transform data.
Using Code Snippets in SSMS
Snippets will allow you to code faster by inserting chunks of code with few key strokes.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
Nomor telepon Call Center AirAsia Indonesia 24 Jam
Saluran Resmi AirAsia: Silakan menghubungi Call Center AirAsia di nomor O.8.2.1.3.1.1.1.1.5.7 atau melalui WhatsApp...
BCA Finance Tangerang Layanan Mobil Tlp/WA.(+62 821°3111°179
Tlp/WA.(+62 821°3111°179 Scientia Garden, Jl. Gading Serpong Boulevard No.1 Blok S, Curug, Kecamatan Kelapa...
BCA Finance WTC Mangga Dua Center.(+62 821°3111°179
Center.(+62 821°3111°179 Gedung WTC Jl. Mangga Dua Raya. 8 Lantai 6, Blok CL 001,...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers