This white paper discusses how to reduce planned and unplanned downtime, maximize application availability, and provide data protection using SQL Server 2012 AlwaysOn high availability and disaster recovery solutions.
Spatial Point Data queries require particular tuning efforts to enhance performance and improve overall application through put. SQL Server 2012 introduces a few key new features and improvements to assist you in that goal.
Database security needs to improve, and while SQL Server continues to get better, there is more work to do. However there are plenty of security issues outside the database that also need to be addressed.
In my last tip, I shared some ideas for determining if you should consider breaking up the e-mail addresses you're storing, even putting the domain names in a separate table. I performed storage and timing comparisons for working with 10,000 unique e-mail addresses, but I completely ignored data compression. I wanted to revisit the same test case and apply data compression to the tables and see how that impacted the outcome.
Part two of this fantastic series from Jeff Moden looks at generating date data, something which can be handy for any number of testing purposes.
Technology has been great for helping us work more efficiently by better sharing resources. Steve Jones sees this as both good and bad in different ways as well as a way of providing new opportunities.
The introduction of the new analytic functions in the RTM version of SQL Server 2012, such as LAG, LEAD, FIRST_VALUE and LAST_VALUE, with the improved over clause, greatly facilitate the analysis on ordered data sets, such as time-series data. Read on to learn more.
Power is a limited resource, but one that's required for computing. Microsoft has a new idea for generating power data centers that Steve Jones likes.
Sometimes we need to import thousands of images to SQL Server. This example shows how to import a list of images to SQL Server using SQL Server Integration Services.
This week Steve Jones talks about forever day bugs, those bugs in industrial systems that haven't been patched, and are not likely to be ever fixed.
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
CSTelpon : 0853-73737551 Jl. Lenteng Agung Raya No.26 E-F, Ps. Minggu, Kota Jakarta Selatan,...
CSTelpon : 0853-73737551 Centennial Tower, Jl. Gatot Subroto No.Kav 24-25 lantai GF unit C,...
CSTelpon : 0853-73737551 Jl. RS. Fatmawati Raya No.6 A, RT.1/RW.5, Cipete Sel., Kec. Cilandak,...
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers