Getting ready for Hadoop
Before adopting Hadoop into your organisation there are a number of factors to consider. This article highlights some of the key points.
2015-11-23
6,383 reads
Articles
SQL Server Heaps, and Their Fragmentation
In SQL Server, heaps are rightly treated with suspicion. Although there are rare cases where they perform well, they are likely to be the cause of poor performance. If a table is likely to have a large number of changes, then it can become fragmented due to way that space is allocated and forward pointers used. How does one detect this problem? Is it significant? How does one deal with it, if necessary? Neeraj Tripathi explains.
2015-11-23
3,694 reads
Using SQL Prompt to Accelerate the Top 10 Most Common Database Scripts
There may be some people who enjoy repetitive typing, but Grant Fritchey doesn't. He's always preferred SQL Prompt. The standard snippets suit developers fine but aren't so DBA-oriented, so he set about asking the SQLServerCentral community what they typed in the most, and set about producing a set of DBA snippets with the results.
2015-11-20
4,144 reads
Installing SQL Server 2016
Greg Larson walks through the GUI installation process for SQL Server 2016 and explore these new installation options.
2015-11-19
4,175 reads
Webinar: Unit Testing in SQL Server with tSQLt
Join tSQLt developer, Sebastian Meine, and Steve Jones as they answer your questions and show you how to unit test T-SQL code.
2015-11-19 (first published: 2015-11-10)
9,014 reads
SQL Prompt Tips #6 - Insert Semicolons
A quick SQL Prompt tip to automatically add semicolons to your code.
2015-11-18 (first published: 2015-01-20)
5,838 reads
Is SQL Server killing your application’s performance?
When an application suffers from performance problems, it’s common to assume the database is at fault. Ben Emmett examines why this often isn’t the case, and shows how you can dig into a .NET application’s use of SQL Server.
2015-11-18
4,405 reads
Database Lifecycle Management Webinar
Join Steve Jones for a Database Lifecycle Management webinar on Nov 17 at 11am EDT. Watch to see how smooth a database development pipeline can be.
2015-11-17 (first published: 2015-11-09)
6,349 reads
Questions About CUBE, ROLLUP and GROUPING SETs That You Were Too Shy to Ask
There are few parts of SQL Syntax as familiar as the GROUP BY clause of the SELECT statement. On the other hand, CUBE and ROLLUP remain mysterious despite their usefulness and GROUPING SET is positively arcane, especially if you are too shy to reveal your ignorance of the subject by asking! William Brewer saves you the hassle.
2015-11-17
4,187 reads
SQL Server 2016 Stretch Database
SQL Server 2016 brings a new feature called Stretch Database, which allows a database to keep transactional data on local instance and warm and cold data on the Azure SQL database platform.
2015-11-16
5,348 reads
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
Cara aktivasi ib token QLola di perangkat lain
aktivasi qlola IB Token BRI (Soft Token) dilakukan melalui whatsapp (O819-6OOO-6O8, Atau 0821_7555_677). unduh...
Cara aktivasi ib token qlola bri
aktivasi qlola IB Token BRI (Soft Token) dilakukan melalui whatsapp (O819>6OOO>6O8, Atau +62 821>7555>677)....
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers