Speeding up database access Part 2 - Pinpointing Other Bottlenecks
Part 2 of a series from Matt Perdeck on speeding up your database access. This is a great series for developers. This is based on the book ASP.NET Site Performance Secrets.
Migrating Microsoft Access Databases to SQL Server 2008
Microsoft Access is a very good database solution, but it has limits. While the portability of mdb and accdb files is convenient, there are advantages to moving to the less portable SQL Server solution. If you do have SQL Server, there's very little reason not to consider migrating your Access Databases. Not all custom-made Access applications easily lend themselves to a SQL Server solution so you'll need to do some analysis before choosing a migration path.
How to create a CLR assembly on a remote server with limited permissions
How to create external_access CLR assembly on remote MS SQL server, when trustworthy option is forbidden, and only SQL login is available
Patches for SQL 10 and Techniques for SQL 11
Steve rounds up the patch news for SQL Server this week along with a look forward to the next version of the platform.
SQLServerCentral Webinar #11 Q&A - A Sandbox Development Process
The answers to questions from our webinar on Sandbox development.
TSQL Challenge 61 - Generate an HTML calendar in TSQL
This challenge is to generate an HTML calendar based on the data stored in a table.
Migrating SQL Server Databases – The DBA’s Checklist (Part 2)
Continuing from Part 1 , our Migration Checklist continues: Step 5: Update statistics It is always a good idea to update the statistics of the database that you have just installed or migrated
SQL Saturday #81 - Birmingham, AL
Come get a free day of SQL Server training in Birmingham on Jul 30, 2011.
"SQL Solstice I: The Dog Days of SQL" Opens For Registration!
Get three days of training in Raleigh, NC on Aug 18-20. There are free and paid options that you can read more about.
SQL Overview VI - Monitoring Process Locks
In the sixth part of his series on monitoring your SQL Server, David Bird looks at process locks.
Blogs
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
T-SQL Tuesday #199: Back to the on-prem
It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s...
Forums
BCA KCU PANAKKUKANG Telp/WA:0817844112
phone/Wa, Cs. 0817844112 Jl. Boulevard No.5 Blok F5, Masale, Kec. Panakkukang, Kota Makassar, Sulawesi...
BCA KCU MAKASSAR Telp/WA:0817844112
phone/Wa, Cs. 0817844112 Jl. Ahmad Yani No.31, Pattunuang, Kec. Wajo, Kota Makassar, Sulawesi Selatan...
BCA KCU AMBON Telp/WA:0817844112
phone/Wa, Cs. 0817844112 Jl. Sultan Hairun No.24, Kel Honipopu, Kec. Sirimau, Kota Ambon, Maluku...
Question of the Day
Converting Money
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers