SQLServerCentral Webinar #25: Best Practices in Database Deployment (Part 1)
SQL Server Central Webinar #25: Best Practices in Database Deployment (Part 1)
2013-09-18
1,030 reads
Additional Articles
SQLServerCentral Webinar #26: Best Practices in Database Deployment (Part 2)
Grant Fritchey (SQL Server MVP) and David Simner (Red Gate developer) give you a step-by-step guide of how you can automate your database deployment Process using Red Gate Deployment Manager.
2013-09-18
277 reads
Installing SQL Server 2014 CTP1
If you are interested in learning firsthand what new features are available, then you should download and install the new SQL Server bits. In this article Greg Larsen will walk you through preparing, downloading and the steps to install the SQL Server 2014 CTP1 release.
2013-09-18
2,741 reads
SQLServerCentral Webinar #17: Monitoring your SQL Server Instances
Join SQL Server MVP Brad McGehee to learn why it is so important to monitor your SQL Server instances and what you should consider when starting out. This webinar will also show you how you can use Red Gate's SQL Monitor for SQL Server monitoring and will include an overview of the new features released in v3.0, including the ability to create your own custom metric definition and to support different access permissions.
2013-09-18 (first published: 2012-04-05)
3,412 reads
SQL Server Analysis Services (SSAS) 2012 Top and Bottom Functions
Scott Murray has used the Top and Bottom T-SQL functions in SQL Server and wonders, do the same functions exist in the SQL Server Analysis Services (SSAS) or MDX? If so, how do they work? Can you provide some examples? Check out this tip to learn more.
2013-09-17
3,320 reads
Backup to the Cloud: The Silver Lining
Offsite backups are vital to data integrity, allowing for preservation and backup of data in catastrophic circumstances. Cloud backups have been around for a while, but are now really coming into their own. Tony Davis looks at how to get set up with cloud backups for restores and disaster recovery.
2013-09-16
2,399 reads
Improved Application Availability During Online Operations in SQL Server 2014
SQL Server 2014 introduces enhancements to two common database maintenance operations namely Partition Switching and Online Index Rebuild which greatly increases enterprise application availability by reducing maintenance downtime impact.
2013-09-13
3,371 reads
Condensing a Delimited List of Integers in SQL Server
In real-world applications, it often makes sense to show denormalized data, such as delimited lists, within the application's user interface. Dwain Camps shows why, and how, the distribution business stores information about 'islands' in sequences in order to track the status of the shipping of a consignment. It makes a great SQL puzzle.
2013-09-12
3,371 reads
Manual cleanup Change Data Capture for a SQL Server database
Kun Lee had a database where the log file kept growing and used 99.99% of the available space. He noticed miscellaneous change data capture objects still in the database as well as open transactions. This was causing his transaction log to continue to grow, but he couldn't disable CDC, because SQL Server thought it was not enabled. Read the full article to see his solution.
2013-09-11
3,682 reads
Compare Big Data Platforms vs SQL Server
SQL is derided by modern developers as 'Scarcely Qualifies as a Language'. But just how efficient are the new wave of NoSQL languages touted by bleeding-edge skunk works? This tip is a defense of SQL and of the relational model, and argues for the efficiency and suitability of relational technology. Check out this tip to learn more.
2013-09-10
4,656 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat kantor BCA KCP Galuh Mas Telp:0817866887
WhatsApp:0817-866-887 Area Street Festival, Ruko No 1 & 1A, CBD, Jl. Galuh Mas Raya,...
Is Fabric a Reliable Service or a Ripped Resource?
Comments posted to this topic are about the item Is Fabric a Reliable Service...
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers