SQL Saturday #115 - Portugal
A free day of SQL Server training in Lisbon. Register and come if you can.
2012-03-06
1,289 reads
Articles
TSQL Challenge 77-Transform monthly resource efforts to weekly actuals
The challenge is to transform monthly resource efforts into weekly actuals.
2012-03-05
735 reads
Working with Perfmon CSV logs in Powershell
When all you have is Powershell and perfmon logs, here's a way you can use them together to perform some analysis.
2012-03-05
4,141 reads
2012-03-05
1,402 reads
The Road to Professional Database Development: Set-Based Thinking
Under the pseudonym of 'SwePeso', Peter Larsson is famous on SQL forums for the amazing performance he can get from SQL. How does he do it? In the first of a series of articles, Peter explains his secrets.
2012-03-05
4,317 reads
Eliminating Duplicate Rows using The PARTITION BY clause
The Partition clause in the Row_Number() Over() function is a quick tool for eliminating duplicate rows.
2012-03-02 (first published: 2010-09-22)
144,055 reads
Exploring SSIS Architecture and Execution History Through Scripting
When you are using SSIS, there soon comes a time when you are confronted with having to do a tricky task such as searching for particular connection strings in all your SSIS packages, or checking the execution history of scheduled SSIS jobs. You can do this type of work effectively in T-SQL as Feodor Georgiev explains.
2012-03-02
2,397 reads
Change the port number for connections to SQL Server
How to change the port number for connections to SQL Server.
2012-03-01
13,673 reads
Potential Security Exploit Using CONTROL SERVER Permissions in SQL Server
In this tip we cover what CONTROL SERVER is, how to detect its use and a possible way to exploit this permission.
2012-03-01
2,469 reads
New User-defined Server Roles in SQL Server 2012
SQL Server 2012 brings new security enhancements, one of which is to create user defined server roles, which simplifies instance wide administration and helps to increase the security of the instance by letting you define different groups with different sets of permissions as per their role and responsibilities.
2012-02-29
3,032 reads
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 KCU DAAN MOGOT TLP/WA 08218573837
By Quay thu XSMN hôm nay - quay thu MN - KETQUA.TV
Jl. Daan Mogot No.95, Wijaya Kusuma, Kec. Grogol petamburan, Kota Jakarta Barat, Daerah Khusus...
BCA KCP Taman Palem Lestari TLP/WA 08216977749
Komp. Perum Jl. Taman Palem Lestari No.C5 No. 9 -11, Cengkareng Bar., Kecamatan Cengkareng,...
BCA KCP Kepa Duri Tlpn/wa0853.7373-7551
Jl. Mangga Raya No.20, Duri Kepa, Kec. Kb. Jeruk, Kota Jakarta Barat, Daerah Khusus...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers