Data pages read from disk are placed in the buffer pool with the intention that they will be reused, and accessing them from RAM is faster than from disk. Knowing how much of your RAM is committed to each database can help you provision the right amount of RAM to SQL Server, and also to identify rogue queries that draw too much data into RAM and force data from other databases out of the cache.
In this article, we will take a look at the following Tips and Tricks for Connection Managers: Adding an "Application Name" property to the connection string; Creating Two Connection Managers for each Database Connection; and Capturing Connection Manager details in Package Configurations
This article provides a solution to executes 32 bit SSIS packages in 64 bit environment.
Protecting our physical systems usually involves some type of security at the office. For many of this, we have some type of key card system. Andy Warren asks today how you handle things and does it work well.
There are a number of new features that became available with SQL Server 2014. One of the more exciting features is the new Memory-Optimized tables. In this article Greg Larson explores how to create Memory-Optimized tables, and what he's found during his initial exploration of using this new type of table.
The PASS Summit is just over a week away, and one again Andy Warren and I are hosting a networking dinner on Monday night. This is a free, informal event to help people get to know each other. Whether you are new to the community or have been to many events, you’re welcome to attend.
Learn how you can use Execute As in a stored procedure to control permissions. This article includes an example that limits access to encryption routines for users.
Red Gate is shipping new features and fixes this week, based on requests from attendees at SQL in the City Charlotte and PASS Summit 2013.
IT is an industry that hasn't adopted a union, at least not yet. Many IT workers hope it never happens, but what if it does? This Friday Steve Jones asks what benefits you might want from a union.
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
Whatsapp 087781685647 Jl. Gajah Mada No.9, RT.002/RW.007, Madawat, Kec. Alok, Kabupaten Sikka, Nusa Tenggara...
Whatsapp 087781685647 Jl. Soekarno - Hatta, Kampung Baru, Atambua, Kec. Tasifeto Tim., Kabupaten Belu,...
Whatsapp 087781685647 Jl. Ahmad Yani, RT.15/RW.006, Matawai, Kec. Kota Waingapu, Kabupaten Sumba Timur, Nusa...
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers