Ports that DBAs Need to Know
This article lists the essential TCP/UDP ports that an administrator running SQL Server or a cluster should know.
2011-10-28
23,372 reads
Articles
“QUOTED_IDENTIFIER” causes Unexpected Query Plan for Persisted Computed Column query
In this blog, you will see the reproducible steps that reveal the following observation: “If the table has a persisted computed column*, the query optimizer will choose a clustered index scan over a clustered index seek.”
2011-10-28
2,092 reads
Identify SQL Server TCP IP port being used
How do I find out what TCP/IP port SQL Server is using for a specific SQL Server instance? In this tip we look at different ways a database administrator can identify the port used by instance of SQL Server.
2011-10-28
6,353 reads
Extract multiple files from multiple directories with a data flow task
This article shows how to extract multiple files from multiple sub-directories into a destination table using a single Data Flow Task created by the Import/Export wizard.
2011-10-27
5,386 reads
2011-10-27 (first published: 2010-01-20)
11,473 reads
Red Gate Acquires Cerebrata
Red Gate announced today that it has acquired Cerebrata, the maker of user-acclaimed tools for developers building on the Microsoft Windows Azure platform. The agreement brings together two companies that share a user-first philosophy and a passion for tools that transform the way developers work.
2011-10-27
565 reads
Identify location of the SQL Server Error Log file
How do I find out where the SQL Server Error Log file is located for a specific SQL Server instance? In this tip we look at different ways a DBA can identify the location of the SQL Server Error Log file used by an instance of SQL Server.
2011-10-27
3,019 reads
An Easy Way to Monitor SQL Server Replication
In SQL Server, replication is a widely adopted technology for the purpose of real-time data replication between SQL servers. It serves the purpose of keeping data consistent between multiple end points. So the last thing we want to hear from clients is that data is no longer in synch, and as DBA, we don't want to be the last person to realize replication is out of order or broken. Here are some steps you can take to monitor SQL Server replication.
2011-10-26
3,444 reads
Come see SQLInspireNYC for FREE – Thanks to Red Gate!
SQLInspire, from SQL People, is coming to New York City on Nov. 12, 2011. Win a free admission from Red Gate software to this great event.
2011-10-25
407 reads
2011-10-25 (first published: 2010-01-06)
11,574 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