Cerebrata has added support for configuring the more detailed level Windows Azure Storage Analytics, as well as managing the Cross-Origin Resource Sharing (CORS) setting.
2014-02-14
1,736 reads
Under heavy load your SQL Server may not work as intended due to lack of resources. To handle this situation SQL Server 2014 gives us the possibility to use an SSD or Ram device to dynamically increase the Buffer Pool. Keep reading to see how you can take advantage of this new wonderful feature.
2014-02-14
2,811 reads
An examination into how the various transaction isolation levels affect locking (and blocking)
2014-02-13
9,041 reads
We’re changing how users get SQL Source Control updates, and we want to learn how users feel about the current update process. Take the survey for a chance to win one of five $25 Amazon vouchers.
2014-02-13
3,013 reads
If, before deployment, you need to push the limits of your disk subsystem in order to determine whether the hardware’s I/O capacity meets the needs of a database application, if you need performance baselines, or if you want to identify any performance-related issues, then why not use the sqlio utility?
2014-02-13
6,077 reads
With the new SQL Server 2014 In-Memory OLTP tables, stored procedures can be natively compiled and can improve performance. Read on to learn more.
2014-02-12
3,945 reads
The 'Structured' part of SQL denotes the fact that queries can be nested inside each other in such a way that, wherever you can use a table, you can use a table expression. Such derived tables can provide powerful magic, to which is added CTEs and Lateral Tables.
2014-02-11
4,675 reads
SQL Server MVP Steve Jones will be hosting a free seminar in San Jose on Friday March 7 2014. Join fellow database professionals to learn best practices and practical tips for SQL Server version control, continuous integration and deployment.
2014-02-11
1,337 reads
We've made a change to the forums at SQLServerCentral. Learn how you can mark a post as an answer to your question and help others.
2014-02-10
696 reads
Not long ago, a crack team of SQL Server experts was flamed for a crime against database normalization they didn't commit. Today, Joe Deebeeay had a problem, no one else could help, so he found these exiled experts. Together Joe and the DBA-Team get to the bottom of high disk I/O.
2014-02-10
2,564 reads
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Many years ago, before I joined Oracle, I was working on a major modernisation...
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Comments posted to this topic are about the item Is Fabric a Reliable Service...
hi , a new user wants to be able to add sql agent jobs...
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