SQLskills Immersion Events - Deep SQL Server Training!
SQLskills is offering a number of intense SQL Server training events later this year. A new class has been added in Chicago in May along with a London event in June.
Stored Procedure Definitions and Permissions
I wrote a post a while back that showed how you can grant execute permission ‘carte blanche’ for a database...
What a week for our first Immersion Event on Internals and Performance
A short writeup on the first Immersion Event from SQLskills, a week long class designed to bring real world skills to DBAs and developers that want to become highly skilled SQL Server professionals.
Implicit and Explicit Conversions
Code that depends on implicit conversions can live for years in production without issue. However Steve Jones says that you shouldn't depend on these conversions
SQL Server 2008 and 2008 R2 Integration Services - Managing Local Processes Using Script Task
SQL Server 2008 R2 Integration Services includes a number of predefined tasks that implement common administrative actions to help with data extraction, transformation and loading (ETL). While in a majority of cases they are sufficient to deliver required functionality, there might be situations where an extra level of flexibility is desired.
SQLPeople: An Interview With Andy Leonard
The thing that I most enjoy about going to conferences, SQLSaturdays, and user group meetings is the people I get...
SSRS: Shared DataSet, Not So Shared!!!
I was really excited about the concept of Shared DataSets when they were introduced. My excitement diminished a little when...
The Business
How is your IT relationship with "the business"? Andy Warren asks today if there is a real client relationship between the implementers of technology and the consumers.
Lipoaspiration in your SQL Server Database
Once, when disk space was at a premium, DBAs fought hard to keep the size of their database down. Now there seems less motivation to 'fight the flab' of a database. Fabiano Amorim was watching television recently when the subject matter, cosmetic surgery, gave him the theme and inspiration for this guide to keeping your database fit and trim.
Restore and Relocate Database Files Using PowerShell
I was recently asked a question on restoring a database using PowerShell with the following requirements
Take a database backup file...
Blogs
VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Free Webinar about Columnstore Indexes
I’m doing a small series on indexing basics for SQL Server, and on May...
Forums
BCA KCP City Center TLP/WA 08216977701
Kawasan Terpadu Pusat Kota, Gedung Perkantoran Tower One, Lantai Dasar, Jl. KH Mas Mansyur...
BCA KCP Menara Imperium TLP/WA 08216977701
Jl. H. R. Rasuna Said No.Kav. 01, Guntur, Kecamatan Setiabudi, Kota Jakarta Selatan, Daerah...
BCA KCP Semanggi TLP/WA 08216977701
Wisma GKBI, Jl. Jend. Sudirman No.28 14, RT.14/RW.1, Tikungan. Hilir, Kecamatan Tanah Abang, Kota...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers