Here's a good one that most people do not know about.We recently moved into a new data centre with an outsourcing provider who implemented a firewall between the data tier (where all the SQL Servers are) and the application tier (where the Exchange server is).The upshot is that although the appropriate holes are available in […]
2005-05-05
Anyone know what this might mean and how I might fix it? Cannot deploy data source MROresults to the server because it already exists and OverwriteDataSources is not specified. Thanks! Kristin
2005-04-28
2 reads
Comments posted to this topic are about the content posted at http://www.databasejournal.com/features/mssql/article.php/3500276
2005-04-28
Comments posted to this topic are about the content posted at http://www.simple-talk.com/2005/04/25/why-bother-with-backup/
2005-04-28
5 reads
Hi Phill, I have thought about the dark side of the article myself... But, I also think that if Administration is done properly, which means Domain admins and SQL Admins are different entities that do not share domain passwords, (and of course passwords are changed regularly as part of the business operational tasks, which is […]
2005-04-25
Hi, We have a new SQL Server 2000 database, and I received the .mdf file, what is the correct step to attach this .mdf into the new database?Thanks.
2005-04-21
Sounds simple, but have you checked the path? I just ran a quick test with the following syntax, and it seems to work fine. Are you getting any errors?: exec master..xp_sendmail @recipients = 'bgates@microsoft.com', @subject = 'test', @attachments = '\\mypath\myfile.txt'
2005-04-21
yes i do..If I follow the steps below I can translate to chinese characters:>Open excel >Open the text file and when it prompts for encoding type to be applied for the columns, on choosing 'Chinese simplified', the supplier name changes to chinese wordI can't do this for every file I receive bcoz the files are […]
2005-04-20
Make sure that the windows firewall on the laptop isn't blocking your PDS'a access.Peter
2005-04-15
1 reads
use db1 go update user1.Table1 set user1.Table1.Site = db2.user2.Table2.OrgName from user1.Table1 inner join db2.user2.Table2 on user1.Table1.site = CONVERT(VARCHAR(10), db2.user2.Table2.OrgId)
2005-04-15
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers